usp_updatetimesheetitem.sql

Beginning VB.NET DatabasesAll_Code.rar

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