Monday, November 16, 2009

UpdateProductProcedure !!

CREATE Procedure UpdateProductProcedure
(
@ProductName varchar(50),
@ProductPrice varchar(50),
@ProductDescription Varchar(100),
@Productid int

)
AS
update tblProduct_Master set

Product_Name=@ProductName,
Product_Price=@ProductPrice,
Product_desc=@ProductDescription
where Product_id=@Productid
GO

No comments: