sqlclr
SQL Server: How to copy a file (pdf, doc, txt...) stored in a varbinary(max) field to a file in a CLR stored procedure?
I ask this question as a followup of this question. A solution that uses bcp and xp_cmdshell, that is not my desired solution, has been posted here.[详细]
2022-12-29 17:12 分类:问答SQLCLR using the wrong version of the .NET Framework
During a recent restart of our development server the SQL Server started using .NET 4.0 for the SQLCLR. This means that nothing using the CLR in SQL works, or at least that\'s my understanding by read[详细]
2022-12-29 15:47 分类:问答.NET framework execution aborted while executing CLR stored procedure?
I constructed a stored procedure that does the equivalent of FOR XML AUTO in SQL Server 2008.Now that I\'m testing it, it gives me a really unhelpful error message.What does this error mean?[详细]
2022-12-28 22:45 分类:问答Is it possible to determine by way of T-SQL Query whether a sproc is CLR-based or regular T-SQL-based?
Hey all.I\'开发者_开发百科m integrating a CLR/Assembly-based sproc replacement for an existing sproc that lives within our production database, and I want to write an update script that only drops the[详细]
2022-12-28 03:46 分类:问答'The default schema does not exist' on deploy of SQL CLR assembly onto SQL Server 2008
I\'m deploying an example SQL CLR stored procedure which has a SQL CLR type as parameter using Visual Studio 2008 and menu Project -&g开发者_如何学运维t; Deploy.[详细]
2022-12-23 14:52 分类:问答How to refactor T-SQL stored procedure encapsulating it's parameters to a class
On my SQL Server 2008 I have a stored procedure with a large number of parameters. The first part of them is used in every call and parameters from the second part are used rarely. And I can\'t move开[详细]
2022-12-23 14:47 分类:问答Memory pressure notification in SQL CLR
Google is not able to tell开发者_StackOverflow社区 me if there is an API available inside the SQL CLR to get memory pressure notification.[详细]
2022-12-22 03:18 分类:问答Executing a VB.NET DLL From SQL Server
Objective: we want to write a DLL using VB.NET 2008 using .Net 3.5 that performs an HTTP request we then want to call the DLL From SQL Server 2005 (in a trigger) and pass the DLL some variables and[详细]
2022-12-18 20:45 分类:问答how to deploy the CLR functions in SQL server 2008
I created a SQL Server Project in VS2008 called \'RegularExpression\'.In that Project i created a \'Regex.cs\' class and i wrote one 开发者_运维知识库function regarding Regular Expression.[详细]
2022-12-18 01:39 分类:问答SQL Server 2008 CLR vs T-SQL: Is there an efficiency/speed difference?
I\'m a C# developer who has done some basic database work in T-SQL. However, I need to write a very complicated stored开发者_开发技巧 procedure, well above my T-SQL knowledge.[详细]
2022-12-16 19:01 分类:问答