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 ...

SQL Server 2005&'s new integrated Visual Studio features allow solution providers, who write lines of business applications, to be more productive by giving them faster access to data and more ...

A CLR UDT has a limit of 8000 bytes - I doubt thats big enough to pack a file into. I guess you could use custom serialization and store the compressed file in a different table using the ...

<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 ...

CLR: Best for code that’s computation- or logic-intensive. A better option than “extended stored procedures,” which Microsoft offered in earlier SQL Server releases for creating server-side code with ...

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 ...