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 2008 Forums
 Transact-SQL (2008)
 difference between SP and extended SPs

Author  Topic 

mikebird
Aged Yak Warrior

529 Posts

Posted - 2013-05-02 : 08:19:04
difference between SP and extended SPs ?

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-05-02 : 08:29:17
Extended stored proc - which is a deprecated feature - allows you to write stored procs in your language of choice and integrate them with SQL Server. If you have a need to write stored procs outside of T-SQL, CLR stored procedures would be much better for a number of reasons. http://msdn.microsoft.com/en-us/library/ms131094.aspx
Go to Top of Page

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-05-02 : 08:31:35
Refer these links....
http://stackoverflow.com/questions/3055975/difference-between-stored-procedures-and-extended-stored-procedures
http://blog.sqlauthority.com/2011/11/26/sql-server-get-directory-structure-using-extended-stored-procedure-xp_dirtree/
http://msdn.microsoft.com/en-IN/library/ms175200(v=sql.105).aspx

--
Chandu
Go to Top of Page
   

- Advertisement -