CREATE PROCEDURE [dbo].[up_update_item_lock] @item_uid [uniqueidentifier], @pwd nvarchar(4) as begin set nocount on update dbo.N_InventoryItem set lock_pwd = @pwd where item_uid = @item_uid end