Browse by Tags
All Tags »
SQLCLR (
RSS)
With all developed and tested on my laptop using SQL Server 2008, it’s time to deploy to the company’s test machine running SQL Server 2005. The first thing I ran into when executing: CREATE ASSEMBLY [MyAssembly] AUTHORIZATION [dbo] FROM '...\MyAssembly...
You might have noticed that I used LINQ in my last Playing With SQL Server CLR Integration posts ( Part I , Part II ). I couldn’t make it work with the standard Visual Studio 2008 SQL CLR project template. Changing the Target Framework to .NET Framework...
On my last post , I showed how to convert a property bag stored in text to a CLR Table-Valued Function . I started thinking that I could retrieve the property values, but I couldn’t change them or add new properties. Passing a table as a parameter is...
I’m currently working with an application that stores a property bag in a SQL Server column like this: [[[name1]]] value1 [[[name2]]] value2.1 value2.2 [[[name3]]] value3 Don’t ask me why it’s done like this. It just is. The application decodes this property...