sqlclr
IN SQL Server is CLR Threadsafe
I have an interface in CLR between SQL Server and the Exchange Web Services to Sync and send emails between applications. In testing this it works(ed) without any problems; we are seeing sporadic issu[详细]
2023-01-10 20:30 分类:问答VS 2010/SQLServer 2005 debugging hangs
When开发者_高级运维 attempt to debug a SQL CLR Function the debugger hangs. Using VS2010 and SQL 2005.the problem appear to be the conflict of Framework, VS2010 uses Framework 4.0 by default.[详细]
2023-01-10 19:54 分类:问答regex split implementation for sql server
I have created a function to implement the regex.split in sql. Here\'s the code: private static IEnumerable&开发者_开发知识库lt;IndexedValue<T>> ToIndexedValue<T>(IEnumerable<T>[详细]
2023-01-10 07:50 分类:问答Why does CREATE ASSEMBLY fail with the error 'Unable to resolve token'?
I\'m working with some SQL 2005 CLR code written in C#. We have recently altered a few of the functions to allow NULL parameters. We did this by changing parameters from \'double\' to \'SqlDecimal\' t[详细]
2023-01-10 01:33 分类:问答SQL CLR trigger: name of the context DB
I\'d like to turn trigger recursion on/off in my SQL CLR trigger. According to http://www.devx.com/tips/Tip/30031, I have to call[详细]
2023-01-09 11:58 分类:问答T-SQL Trigger calling SQLCLR Stored Procedure vs SQLCLR Trigger
Are there any benefits to calling a SQLCLR stored procedure from a regular T-SQL trigger rather than deploying a SQLCLR trigger straight away?[详细]
2023-01-08 09:04 分类:问答SQL Server 2008: Exception when excecuting CLR function which tries to access database through a connection
I want to use CLR table-valued function in SQL Server 2008, which accesses a database from inside itself. I\'ve got a permission exception. I am trying to execute function as the same user as under wh[详细]
2023-01-08 03:12 分类:问答Converting project to SQL Server, design thoughts?
Currently, I\'m sitting on an ugly business application written in Access that takes a spreadsheet on a bi-daily basis and imports it into a MDB.I am currently converting a major project that includes[详细]
2023-01-07 14:08 分类:问答How to make this CLR work with 2005?
I am trying to make a clr stored procedure for a sql 2005 database that uses .net 3.5 assemblies So first I had to change sql 2005 to recognize system.core as unsafe what I am not too happy about(I r[详细]
2023-01-06 17:41 分类:问答I'd like to know, what columns have been REALLY changed
I have an after trigger implemented in SQLCLR assembly. Within it I\'d like to know, what columns have been really updated (and their values have been changed).[详细]
2023-01-06 13:22 分类:问答