ALTER PROCEDURE [dbo].[updateitems] @itemcode11 char(10), @itemname char(20) AS BEGIN SET NOCOUNT ON; update dbo.items set ItemName = @itemname where ItemCode=@itemcode11 END