?? bugnet_attachment_getattachmentsbybugid.sql
字號(hào):
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BugNet_Attachment_GetAttachmentsByBugId]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[BugNet_Attachment_GetAttachmentsByBugId]
GO
CREATE PROCEDURE [dbo].[BugNet_Attachment_GetAttachmentsByBugId]
@BugId INT
AS
SELECT
BugAttachmentId,
BugId,
FileName,
Description,
FileSize,
Type,
UploadedDate,
UploadedUserId,
Creators.UserName CreatorUserName
FROM
BugAttachment
INNER JOIN aspnet_users Creators ON Creators.UserId = BugAttachment.UploadedUserId
WHERE
BugId = @BugId
GO
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -