Update Procedure !!

CREATE PROCEDURE adminprojectupdate
(
@code varchar (50),
@startdate datetime,
@enddate datetime,
@amount varchar(50),
@title varchar (50),
@client varchar (200),
@des varchar (200),
pid int

)
as
update tblprojectmaster

pr_code=@code,
pr_startDate=@startDate,
pr_endDate=@amont,
pr_title=@title,
pr_client=@client,
pr_desc=@desc;

where pr_id=@pid

Go