T-SQL is great for database code, but writing procedural code in T-SQL has always been difficult. Invariably, your project includes a stored procedure or two, requiring some text parsing or complex ...

The Common Language Runtime is at the heart of Microsoft’s .NET vision. It promises to co-opt the benefits of Java–it’s a run-time environment that features a just-in-time compiler and built-in ...

This is my first time trying to use SQL CLR, so if I'm missing something obvious, I'm sorry.<BR><BR>So I have a SQL CLR function that takes a long list of comma-separated guids in a string and returns ...

I've googled for this on several occasions, but not really found any good information. I have a SQL 2005 CLR procedure that builds dynamic (parameterized) SQL. I basically have a main statement, and a ...

<Microsoft.SqlServer.Server.SqlFunction()> Public Shared Function fnIsNumeric(field As SqlString, sqltype As String) As SqlBoolean Dim result As New SqlBoolean(0) 'default to False Dim errorMessage As ...