suppose we want to create a data table,we have a fields empid,empname,empsalary means ,we can create a table using,
create table employee(empid varchar(50),empname varchar(50),empsalary varchar(50))
//table created successfully..
//now the insert SP.
---------------------
create procedure empinsert(empid varchar(50),empname varchar(50),empsalary varchar(50))
as begin
insert into emloyee(empid,empname,empsalary)values(@empid,@empname,@empsalary)
end
delete code in SP
-----------------
create procedure empdelete(@empid varchar(50))
as begin
delete employee where empid=@empid
end
view code in SP
---------------
create procedure empview(empid varchar(50))
as begin
select * from employee where empid=@empid
end
friends , these are the sample codes in Stored Procedure(SP).if any body need some advantage codes post a command to me........thank you
|
| Author: Kapil Dhawan 17 Jun 2008 | Member Level: Gold Points : 2 |
Hello
Nice piece of code
Thanks for sharing your knowledge with us.
I hope to see more good code from your side
This code is going to help lots of guys.
Ton Thanks to you
Regards,
Kapil
|