usp_approvetimesheet.sql

来自「Beginning VB.NET DatabasesAll_Code.rar」· SQL 代码 · 共 18 行

CREATE PROCEDURE usp_ApproveTimeSheet
(
   @TimeSheetID   UNIQUEIDENTIFIER,
   @ManagerID     UNIQUEIDENTIFIER
)
AS

UPDATE TimeSheets
   SET ApprovalDate = GETDATE(),
   ManagerID = @ManagerID
   WHERE TimeSheetID = @TimeSheetID

IF @@ERROR <> 0 
   BEGIN
   RAISERROR('Approve timesheet failed.',18,1)
   RETURN
   END