?? bugnet_project_getprojectbycode.sql
字號:
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BugNet_Project_GetProjectByCode]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[BugNet_Project_GetProjectByCode]
GO
CREATE PROCEDURE [dbo].[BugNet_Project_GetProjectByCode]
@ProjectCode nvarchar(3)
AS
SELECT
ProjectId,
Name,
Code,
Description,
UploadPath,
ManagerUserId,
CreatorUserId,
CreateDate,
Project.Active,
AccessType,
Managers.UserName ManagerDisplayName,
Creators.UserName CreatorDisplayName,
AllowAttachments
FROM
Project
INNER JOIN aspnet_users AS Managers ON Managers.UserId = Project.ManagerUserId
INNER JOIN aspnet_users AS Creators ON Creators.UserId = Project.CreatorUserId
WHERE
Code = @ProjectCode
GO
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -