?? bugnet_comment_getcommentbyid.sql
字號:
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BugNet_Comment_GetCommentById]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[BugNet_Comment_GetCommentById]
GO
CREATE PROCEDURE [dbo].[BugNet_Comment_GetCommentById]
@BugCommentId INT
AS
SELECT
BugCommentId,
BugId,
BugComment.CreatedUserId,
CreatedDate,
BugComment.Comment,
Creators.UserName CreatorUserName,
Membership.Email CreatorEmail
FROM
BugComment
INNER JOIN aspnet_users Creators ON Creators.UserId = BugComment.CreatedUserId
INNER JOIN aspnet_membership Membership on Creators.UserId = Membership.UserId
WHERE
BugCommentId = @BugCommentId
GO
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -