Lab Sql

The code I was given for an SQL CLR project contains one function where the .net implementation is … Read more How Can I Get The Definition Of A Sql Clr Function From The Database

I have a SQL CLR function which at the moment returns a string seperated by a comma. How would I co… Read more Sql Clr Return Two New Columns

SQL Server keeps loading and unloading my Assemblies, marking them as unsafe. Any ideas why it woul… Read more Assemblies In Sql Server Keep Unloading And Loading Again Periodically

I ask this question as a followup of this question. A solution that uses bcp and xp_cmdshell, that … Read more Sql Server: How To Copy A File (pdf, Doc, Txt...) Stored In A Varbinary(max) Field To A File In A Clr Stored Procedure?

I am currently receiving an error when trying to execute a simple SELECT statement that references … Read more Sqlclr .net Error: Object Reference Not Set To An Instance Of An Object

I have a SQL CLR function like this one: public partial class UserDefinedFunctions { [Microsoft… Read more Clr Table-valued Function With Array Argument

I wanted to update the values of a few columns of a database table, using queries or stored procedu… Read more Can I Use Sqlclr Stored Procedure To Update A Column Of A Database Table ( Using Some Compiled Dll)

I have a generic clr trigger which can be attached to different tables on insert, update, delete. e… Read more Retrieve The Sqlobject That Fired The Trigger In Clr