Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 STORE PROCEDURE creation

Author  Topic 

vipin_jha123
Starting Member

31 Posts

Posted - 2011-03-21 : 07:38:19
Dear Sir ,
I am very much new to the sql coding.
i want to know how to create ta store procedure in sql 2005 step by step. on the basis of multiple table .
please take the example of employee and department table.

i want to know both kind of procedure with parameter and without parameter .

hope to hear you soon .

thankx in advance

Vipin jha

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2011-03-21 : 07:48:38
Vipin step by step instructions with examples are available on this page: http://msdn.microsoft.com/en-us/library/ms345415.aspx
Go to Top of Page

vipin_jha123
Starting Member

31 Posts

Posted - 2011-03-23 : 08:12:52
will any one give an example of creating a store procedure .

thanks in advance.

regards
Vipin jha
Go to Top of Page
   

- Advertisement -