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.
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
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?
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
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.
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开
Google is not able to tell开发者_StackOverflow社区 me if there is an API available inside the SQL CLR to get memory pressure notification.
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
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.
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.
加载中,请稍侯......