store proc

create proc [dbo].[UpdateAddClient]
@ID numeric(10, 0),
@Applicant nvarchar(50),
@REFRANCE nvarchar(50),
@FLATTYPE nvarchar(50),
@REMARK1 nvarchar(50),


as
begin
update CLIENT  set Applicant=@Applicant,REFRANCE=@REFRANCE,FLATTYPE=@FLATTYPE,REMARK1=@REMARK1
end