sqlclr
Replicate SQL Server CLR Function
Is it possible to replicate a CLR Function using Transact开发者_JAVA百科ional (or Merge) Replication?Yes. See: Publishing Data and Database Objects[详细]
2023-02-09 07:02 分类:问答sql clr timeout
I have a CLR Stored procedure thatcalls a webmethod. The webmethod call is a somewhat long running taks ( about 3 minutes to complete). The CLRsp does not call Sql server at all, However it times out.[详细]
2023-02-07 01:33 分类:问答CLR Table-valued function with array argument
I have a SQL CLR function like this one: public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server.SqlFunction(TableDefinition = \"number int\", FillRo开发者_Python百科wMethodName = \"F[详细]
2023-02-05 13:27 分类:问答can you access soap xml's in SQL and parse it in XQuery without the use of CLR?
开发者_JS百科as the title suggests, is this possible?At a superficial level yes, it is possible. But would you want to re-implement in SQL the entire SOAP stack to validate the message for ws-security[详细]
2023-02-05 04:35 分类:问答Que Sera, Sera! Net Framework 4.0 support for SQL 2008?
I did substantial workdeveloping CLR routines to implement DAL functionality using VS2010 intending to port them to SQL2008R2 clr assemblies;[详细]
2023-02-03 13:27 分类:问答SQL Server CLR Integration to achieve Encryption/Decryption
I have a requirement to store the data in encrypted form in database tables. I want to do it at the database level but here are the problems I am facing:[详细]
2023-02-03 11:50 分类:问答Move SELECT to SQL Server side
I have an SQLCLR trigger. It contains a large and messy SELECT inside, with parts like: (CASE WHEN EXISTS(SELECT * FROM INSERTED I WHERE I.ID = R.ID)[详细]
2023-02-02 16:42 分类:问答SQL Server 2008 Receive an user-defined table type in a CLR Stored Procedure?
I have table-valued parameters in SQL Server 2008, e.g.: CREATE TYPE UserType AS TABLE ( UserI开发者_运维百科D int,[详细]
2023-02-02 06:06 分类:问答SQL Server -- Handling null input in CLR User-Defined Function (UDF) with OnNullCall
I have a user-defined function in SQL Server (written in .NET) that cleans text.I\'m wondering how to handle null input.[详细]
2023-02-01 15:23 分类:问答What considerations go with SQL/CLR integration when database is live and changes are frequent?
I just now for the very first time made a CLR function and deployed it into a database, and after reading a little about how it works, think it\'s a good option for a C# programmer like me.[详细]
2023-01-31 03:41 分类:问答