Hi
What is an extended stored procedure. Can you instantiate a COM object by using T-SQL ?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Apr 17, 2012, 12:27 AM
In SQL Server 2005 and later version of it database objects can be created which are created in CLR. Stored Procedures, Functions, Triggers can be coded in CLR. CLR is faster than T-SQL in many cases. CLR is mainly used to accomplish task which are not possible by T-SQL or can use lots of resources. CLR can be usually implemented where there is intense string operation, thread management or iteration methods which can be complicated for T-SQL.
please refer
http://msdn.microsoft.com/en-us/library/ms164653.aspx
http://msdn.microsoft.com/en-us/library/ms190790%28v=sql.105%29.aspx
hope this help.
VulpesPosted Apr 15, 2012, 9:09 AM