Monday, August 10, 2009

User Defined Functions

'...if you have ever wanted to use the results of a stored procedure as part of a T-SQL command, use parameterized non-updateable views, or encapsulate complex logic into a single database object, the SQL Server 2000 User-Defined function is a new database object that you should examine to see if its right for your particular environment.'

http://www.sqlteam.com/article/user-defined-functions

CLR Stored Procedures

http://msdn.microsoft.com/en-gb/library/ms131094.aspx

http://www.devx.com/dbzone/Article/28412/1954

http://www.amergerzic.com/post/CLRStoredProcedures.aspx

http://aspalliance.com/1338_Working_with_Managed_Stored_Procedure_using_Visual_Studio_2005.5