sqlclr
Matching multiple variations of input to one sql row
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:[详细]
2023-04-11 02:34 分类:问答Invoking SMO via T-SQL?
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[详细]
2023-04-10 23:07 分类:问答How do I deploy a CLR Stored Procedure via the MsBuild command line?
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[详细]
2023-04-09 23:35 分类:问答How can I use SQL Server Profiler to view the TSQL ran in a CLR trigger?
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[详细]
2023-04-09 10:22 分类:问答Is it possible to create table-valued *methods* in a SQL CLR user-defined type?
I have a CLR UDT that would benefit gr开发者_运维技巧eatly from table-valued methods, ala xml.nodes():[详细]
2023-04-09 10:15 分类:问答T-SQL (varchar(max) vs CLR (string, SqlString, SqlChars)?
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[详细]
2023-04-09 03:39 分类:问答SQL CLR Trigger - get Target / Table name
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?[详细]
2023-04-07 15:05 分类:问答Cannot find the asymmetric key -- because it does not exist or you do not have permission
I am trying to be able to run a .Net dll through SQL using the CLR - I a开发者_运维百科m doing so unsuccessfully.[详细]
2023-04-06 17:08 分类:问答Disable Type in code running on the SQLCLR
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[详细]
2023-04-05 20:57 分类:问答sqlFileStream System.ComponentModel.Win32Exception: The request is not supported
I have SQL server express 2008 SP1 on windows 7 (Version 6.1 Build 7601: Service Pack 1) and visual studio 2010.[详细]
2023-04-05 03:05 分类:问答