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 分类：问答