The following code sample shows how to create Procedure for inserting
create table emp (firstname varchar(50),lastname varchar(50),middlename varchar(50),id int ,salary varchar(50),dateofbirth varchar(50))
create procedure sp_insert
@firstname varchar(50),
@lastname varchar(50),
@middlename varchar(50),
@id int,
@salary varchar(50),
@dateofbirth varchar(50)
as
insert into emp values(@firstname,@lastname,@middlename,@id,@salary,@dateofbirth)
go
exec sp_insert sruthi,palla,vv,8,5000,sep1
select * from emp
|
| Author: Sonu Fernandes 24 May 2008 | Member Level: Gold Points : 2 |
Nice Code Sample
|