By Bill Graziano on 14 October 2003 | Tags: Stored Procedures , CLR
This nifty little piece of code will allow you to call a .NET routine from inside a stored procedure.
Link: Run CLR code from a stored procedure
Handling SQL Server Errors (5 April 2010)
Testing with Profiler Custom Events and Database Snapshots (22 June 2009)
Debugging Stored Procedures in Visual Studio 2005 (25 June 2007)
Writing CLR Stored Procedures in C# - Returning Data (Part 2) (23 June 2005)
Writing CLR Stored Procedures in C# - Introduction to C# (Part 1) (6 June 2005)
Managed Data Access Inside SQL Server with ADO.NET and SQLCLR (31 May 2005)
Using CLR Integration in SQL Server 2005 (29 November 2004)
An Evaluation of Stored Procedures for the .NET Developer (22 March 2004)
Return all rows from first table & specific values from joined table? (3d)
Distinct number in column with max value in another column (4d)
SQL System Databases (4d)
Performance improvement - using temp table (4d)
Generate a Create Table Statement with a SQL Query but with Flexible Datatypes (6d)
Filter Date Range (6d)
Beat methods to validate/test the output data with original data (6d)
Access temp tables already created from within dynamic OpenQuery (6d)
SQLTeam.com Articles via RSS
SQLTeam.com Weblog via RSS
- Advertisement -
Articles
Forums
Blogs
Contact Us
About the Site