sqlclr
unable to deploy sql clr stored procedure (unable to verify metadata)
I am trying to run the CREATE ASSEMBLY command for a SQL CLR (.Net 3.5) assembly on SQL Server 2008.It returns a cryptic error message:[详细]
2023-01-29 12:56 分类:问答How to have a sql_variant parameter for a SQL CLR stored procedure?
How can one add开发者_如何转开发 a sql_variant parameter to a SQL CLR stored procedure?Using System.Object does not work, and I don\'t see any attributes that I can use.[详细]
2023-01-29 03:34 分类:问答How to execute sub-tasks in a SQL Procedure in parallel
I have a process开发者_运维百科 that analyzes audit data from one system to build reporting data for another system.There is a managing procedure that loops for each day to be analyzed and calls a ent[详细]
2023-01-27 22:02 分类:问答SQL CLR Error, or Bug?
I\'m running some C# code inside of a CLR Function and running into some strange behavior. When the following code runs:[详细]
2023-01-27 07:21 分类:问答Is it possible to decompile a SQL Server CLR stored procedure assembly?
We\'ve got a few internal proprietary database CLR stored procs (MSSQL 2005) that were put together by a former employee who misplaced (and never checked in) the .NET source code used to build the ass[详细]
2023-01-25 17:13 分类:问答Get the T-SQL CREATE statement for SQLCLR stored procedures
I have an application that retrieves the text of stored procedure开发者_JAVA技巧s using sp_helptext.It works great on all my stored procedures except for CLR stored procedures.If I try to use sp_helpt[详细]
2023-01-24 00:48 分类:问答Integrating .NET and MSSQL Server, How to create 'scalar, user-defined' functions perched upon state
I am called upon to deliver some .NET (C#) code for use in MSSQL Server by conforming to the MS Spec for user defined functions. This code has to read in a file of state and hang onto it, and then use[详细]
2023-01-23 17:31 分类:问答TSQL - Executing CLR Permission
I got a sql procedure from a CLR (.net Assembly) that when executed returns an error Msg 6522, Level 16, State 1, Procedure sp_HelloWorld, Line 0[详细]
2023-01-23 10:05 分类:问答Why can I not register System.Web in SQL Server 2008?
Running this command: CREATE ASSEMBLY [System.Web] from \'C:\\Windows\\Microsoft.NET\\Framework\\v2.0.50727\\system.web.dll\'[详细]
2023-01-23 06:45 分类:问答Can I use Razor (or similar) in a regular .NET class, i.e. get string interpolation of sorts?
I could\'ve sworn I saw som开发者_运维百科e articles a while ago about imperfect but useful string interpolation methods for C, but no such luck right now. However, there\'s Razor, which does more or[详细]
2023-01-21 09:37 分类:问答