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
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.
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
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
What are the limitations, unexpected pitfalls and performance traits of moving from in process C# code to SQL CLR Functions?
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.
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
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/
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.
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
加载中,请稍侯......