In SQL Server 2005 and 2008 the Common Language Runtmie (CLR) is tightly integrated with the database engine, allowing you to write stored procedures in any .NET language such as C# and VB.NET. CLR stored procedures have some distinct advantages over traditional stored procedures, and they also have...
In order to make CLR stored procedures run, you must first enable the CLR in SQL Server, other wise you will just get this error: Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option. Enabling the CLR is fairly simple, just run this SQL Statement...
On a few of the mailing lists I am on for developers (primarily ones related to web development), there is a recurring topic that always gets people into rather heated debates: to use stored procedures or prepared statements? Now, either one you choose to use, is largely dependent on two things: preference...
Today we had a need for a query that would return information on a stored procedure and give us a list of parameters, datatypes, and max values. This functionality is built into the data adapter but we wanted a little bit more flexibility on how we used the data that was returned. Here is what we came...