usp_submittimesheet.sql

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

CREATE PROCEDURE usp_SubmitTimeSheet
(
   @TimeSheetID   UNIQUEIDENTIFIER
)
AS

UPDATE TimeSheets
   SET Submitted = 1
   WHERE TimeSheetID = @TimeSheetID

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