ALTER PROCEDURE [OS].[UPDATE_ItemsRecords] @itemID varchar(10), @itemName varchar(1000), @itemDesc varchar(10) AS Select @itemName = itemName, @itemDesc = itemDesc from OS.Items WHERE itemID = @itemID UPDATE OS.Items SET itemName = @itemName , itemDesc = @itemDesc WHERE itemID = @itemID