The following code sample shows how to create a procedure for updating
create procedure sp_update
@firstname varchar(50),
@lastname varchar(50),
@middlename varchar(50),
@id int,
@salary varchar(50),
@dateofbirth varchar(50)
as
update emp set firstname = @firstname,lastname= @lastname,middlename = @middlename,salary = @salary,dateofbirth = @dateofbirth where id = @id
go
exec sp_update srujan ,srujan, svv,1,5555,august
|
| Author: Sonu Fernandes 24 May 2008 | Member Level: Gold Points : 2 |
Nice Code Sample
|