sqlclr
SQL CLR DDL trigger written on C#
Is it possible to create a database/DDL trigger in C#?And, if so, then how? [EDIT] Basically, I decided to use CLR for the database trigger becau开发者_开发技巧se I want to utilize C# SMO to script[详细]
2023-01-21 08:01 分类:问答How to detect SQL Hosted CLR at runtime
I would like to detect that my assembly is loaded in SQL Hosted CLR at runtime in order to safely process the AppDomain FriendlyName string.[详细]
2023-01-21 02:54 分类:问答How to call C# function in stored procedure
SQL Server 2005 supports CLR开发者_如何学Go so it means we can use CLR in backend so how to do that, I have some function in c# which do some complex manipulation with date-time variable now I want to[详细]
2023-01-20 21:11 分类:问答Computed columns in SQLCLR project in Visual Studio 2010
It appears that MS has a bug when dealing with VS 2010 SQL CLR project and computed columns. I am using Pre/Pos开发者_开发知识库tDeployScript.sql to drop/add the computed column. However, if I try to[详细]
2023-01-20 10:58 分类:问答Moving C# in Process Functions to SQL Server CLR functions
What are the limitations, unexpected pitfalls and performance traits of moving from in process C# code to SQL CLR Functions?[详细]
2023-01-18 10:27 分类:问答SQL Server 2008 and HashBytes
I have quite a large nvarchar which I wish to pass to the HashBytes function. I get the error: \"String or binary would be truncated.[详细]
2023-01-16 19:09 分类:问答SQL Server 2008 and COM server programming
We need to access a custom ATL COM server from SQL server 2008. Ideally we want the COM server to live on a separate machine since it is part of a larger software application. I know of the COM/OLE au[详细]
2023-01-14 06:01 分类:问答SQLCLR & IronPython
Im feeling crazy and I\'ve decided I would really like to write a User-Defined Function in Python that would run in SQL Server 2008. I am interested in doing this as I have a few thousand lines of PL/[详细]
2023-01-12 11:38 分类:问答CLR SQL Server 2005 procedure to take stored procedure results as a parameter
I have a stored procedure that returns a rowset that I\'d like to pass into a开发者_如何转开发 CLR stored procedure to do some advanced calculations.[详细]
2023-01-11 23:10 分类:问答writing t-sql version of .net codes by using sqlclr
i ha开发者_如何学Gove a lot of methods wrote with.net codes (c#) to using with linq queries. but i have problem to translating methods to t-sql. and i want to convert that to t-sql functions and using[详细]
2023-01-10 23:12 分类:问答