Example:

create procedure spEmployeeUpdate

(

@EmpId integer,

@Name char(75),

@Salary decimal(8, 2)

)

as

update employee set [name] = @Name, Salary = @Salary where empid = @EmpId