I would like to know after much searching how I would match different variations of input to one sql row using standard TSQL. Here is the scenario:
I\'d like to use SMO to do several things that aren\'t easily done in T-SQL. However, all the examples I\'ve found are for C# or Powershell.Is there an easy way to invoke SMO via T-SQL, as you could d
I can deploy a SqlClr project projec开发者_如何学运维t from Solution Explorer by right clicking it an selecting Deploy. However, I would like a command lineversion where I can also specify custom Conn
How can I user SQL Server Profiler to view the TSQL ran in a CLR trigger? I have a CLR trigger in the a MS SQL Server 开发者_运维百科DB, that checks the Inserts, Updates, Deletes on a table and then
I have a CLR UDT that would benefit gr开发者_运维技巧eatly from table-valued methods, ala xml.nodes():
I have a problem, that I can\'t solve. I\'m using SQL Server 2005, C# CLR for using outer dll. The problem is at length of parameter. I need to use as function parameter type varchar(max). If at C# co
Track column changes - single SQL CLR Trigger for multiple Targets/Tables SQL CLR Trigger: Is there a开发者_C百科 way to get Target / Table name from CLR code?
I am trying to be able to run a .Net dll through SQL using the CLR - I a开发者_运维百科m doing so unsuccessfully.
Recently I\'ve managed to get the Razor parser working under .NET 3.5 and hosted by SQL Server 2008. At the moment, it\'s really just an experiment to see what is feasible.This is working, including d
I have SQL server express 2008 SP1 on windows 7 (Version 6.1 Build 7601: Service Pack 1) and visual studio 2010.