SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 difference between SP and extended SPs
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 05/02/2013 :  08:19:04  Show Profile  Reply with Quote
difference between SP and extended SPs ?

Edited by - mikebird on 05/02/2013 11:52:26

James K
Flowing Fount of Yak Knowledge

3575 Posts

Posted - 05/02/2013 :  08:29:17  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

India
2206 Posts

Posted - 05/02/2013 :  08:31:35  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000