what is types of storedprocedure in sqlo server 2005

Posted by Venky.Net under Sql Server on 4/14/2012 | Points: 10 | Views : 1570 | Status : [Member] | Replies : 4
hi
what is types of storeprocedure in sql server 2005?




Responses

Posted by: Santosh.Choudhury on: 4/14/2012 [Member] Starter | Points: 25

Up
0
Down
http://msdn.microsoft.com/en-us/library/ms187644%28v=sql.90%29.aspx go through it

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sakthi.Singaravel on: 4/17/2012 [Member] Silver | Points: 25

Up
0
Down
See this..

http://msdn.microsoft.com/en-us/library/ms187644(v=sql.100).aspx

Regards,
Singaravel M

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 5/19/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,

There are 5 Types of Stored procedure in SQL Server

1) SYSTEM STORED PROCEDURE
2) USER DEFINED STORED PROCEDURE
3) TEMPORARY STORED PROCEDURE.
4) EXTENDED STORED PROCEDURE
5) REMOTE STORED PROCEDURE

HOPE THIS WILL HELP

REGARDS
SRIRAM.R

sriram

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ajay.Kalol on: 5/21/2012 [Member] Starter | Points: 25

Up
0
Down
http://www.dotnetfunda.com/forums/thread9208-what-is-stored-procedure-and-types.aspx

here is same question's solution

enjoy....

Ajay
ajaypatelfromsanthal.blogspot.in

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response