CLR Integration in SQL Server 2005 Using Visual Studio 2005 – Part 2
page 8 of 8
by Soyuj Kumar Sahoo
Feedback
Average Rating: 
Views (Total / Last 10 Days): 42856/ 71

Conclusion

The above discussion describes an easier way of creating CLR integrated database objects than the previous one, discussed in my first article. It uses the Visual Studio 2005 which is very familiar to all of us. This is very helpful when we develop an application in Remote machine. Again, CLR integrated user defined functions (UDFs) have some added advantage over T-SQL UDFs. In the case of Table-Valued Functions (TVFs), Transact-SQL materializes the results of calling the function into an intermediate table, while CLR TVFs represent a streaming alternative.

By

Soyuj Kumar Sahoo

Mindfire Solutions

 

 

         

 


View Entire Article

User Comments

Title: Update?   
Name: Apuma
Date: 2010-02-03 7:17:37 PM
Comment:
Can we see an example using VS 2008?
Title: Bout the article..   
Name: ainOmar
Date: 2007-05-13 10:57:53 PM
Comment:
can u simply attach more samples using .net clr
Title: Nice Article   
Name: Abhishek
Date: 2007-02-21 4:50:26 AM
Comment:
Nice article to work with .net CLR.

Product Spotlight
Product Spotlight 





Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2021 ASPAlliance.com  |  Page Processed at 2021-01-24 10:26:35 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search