usp_updatetimesheetitem.sql

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

CREATE PROCEDURE usp_UpdateTimeSheetItem
(
   @TimeSheetItemID   UNIQUEIDENTIFIER,
   @Hours             TINYINT
)
AS

UPDATE TimeSheetItems
   SET Hours = @Hours
   WHERE TimeSheetItemID = @TimeSheetItemID

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