MSSQLストレージ・プロシージャの作成

--        

--              ，        
IF EXISTS(SELECT * FROM sysobjects WHERE name='StaffInfoSel')
DROP PROC StaffInfoSel
--           GO
GO
CREATE PROCEDURE StaffInfoSel
AS
    SELECT StaffNum,StaffName,StaffPhone,StaffDepartment.StaffDepartName,StaffRemark,CASE StaffInfo.StaffState WHEN 'True' THEN '  ' WHEN 'False' THEN '  ' END newStaffState,CASE StaffInfo.IsLeader WHEN 'True' THEN ' ' WHEN 'False' THEN ' ' END newIsLeader,CASE StaffInfo.IsAdmin WHEN 'True' THEN ' ' WHEN 'False' THEN ' ' END newIsAdmin FROM StaffInfo LEFT JOIN StaffDepartment ON StaffInfo.StaffDepartID = StaffDepartment.StaffDepartID
GO

--    

--              ，        
IF EXISTS(SELECT * FROM sysobjects WHERE name='StaffInfoSel')
DROP PROC StaffInfoSel
--           GO
GO
CREATE PROCEDURE StaffInfoSel
 @hero nvarchar(20) = NULL
AS
IF @hero IS NULL
BEGIN

END
    SELECT StaffNum,StaffName,StaffPhone,StaffDepartment.StaffDepartName,StaffRemark,CASE StaffInfo.StaffState WHEN 'True' THEN '  ' WHEN 'False' THEN '  ' END newStaffState,CASE StaffInfo.IsLeader WHEN 'True' THEN ' ' WHEN 'False' THEN ' ' END newIsLeader,CASE StaffInfo.IsAdmin WHEN 'True' THEN ' ' WHEN 'False' THEN ' ' END newIsAdmin FROM StaffInfo LEFT JOIN StaffDepartment ON StaffInfo.StaffDepartID = StaffDepartment.StaffDepartID
GO