No announcements
Found 1816170 threads
-
0 VotesConvert Existing Stored Procedure To CLR Stored Procedure
Your stored procedure is almost completely SQL statements, so converting it to .NET would not only be slower, but possibly less secure (because users would need direct table access).Answered | 1 Replies | 6944 Views | Created by azinyama - Monday, November 5, 2012 8:55 AM | Last reply by Bob Beauchemin - Monday, November 5, 2012 5:59 PM
-
0 Votes
Step into a SQL Stored Procedure from a CLR Stored Procedure debugging session
Right click on the SQL Server that you just added and make sure that both Application Debugging and Allow SQL/CLR Debugging are checked.Answered | 6 Replies | 535 Views | Created by JayW06 - Tuesday, February 27, 2018 6:15 PM | Last reply by JayW06 - Monday, March 5, 2018 3:06 PM -
0 Votes
Is it clr stored procedure?
I think that you should first compile your code using Visual Studio (obtaining a .DLL file), then go to Management Studio and execute CREATE ASSEMBLY …, then CREATE PROCEDURE ...Answered | 3 Replies | 423 Views | Created by HZ.USA - Monday, April 6, 2015 5:10 PM | Last reply by Viorel_ - Monday, April 6, 2015 7:05 PM -
0 Votes
CLR based Stored procedure with sp_MS_marksystemobject
Hi, I have bunch of databases with the same structure and i would like to add CLR based stored procedure and would like to use this across all the ...Answered | 1 Replies | 4726 Views | Created by sNu - Friday, January 22, 2010 8:50 PM | Last reply by Olaf Helper - Sunday, January 24, 2010 11:51 AM -
0 Votes
Optional Parameters for CLR Stored Procedure
How do I specify optional parameters when writing CLR based Stored Procedures in C#?Answered | 12 Replies | 28500 Views | Created by Derek S. Smith - Tuesday, October 2, 2007 1:17 AM | Last reply by Solomon Rutzky - Tuesday, July 21, 2015 9:31 PM -
0 Votes
SQL CLR stored procedures & functions
I am new to writing SQL CLR stored procedures & functions.Answered | 3 Replies | 3873 Views | Created by CSharp Enthusiast - Tuesday, June 25, 2013 8:46 PM | Last reply by CSharp Enthusiast - Wednesday, June 26, 2013 3:09 PM -
0 Votes
Synclock in CLR Stored Procedure
Dear All, I start a SQL Server Project, and write a CLR Stored Procedure.Answered | 1 Replies | 9632 Views | Created by Bjørn Sigurd - Thursday, September 4, 2008 8:45 PM | Last reply by Shrikant Maske - Monday, November 3, 2008 8:09 AM -
0 Votes
CLR Trigger with stored procedures - transaction error
I'm not sure but in my case when I use CLR procedure and call some stored procedure, functions etc which fail, the CLR procedure fail too.Answered | 7 Replies | 14238 Views | Created by Lukas.Kubis - Friday, July 30, 2010 6:17 PM | Last reply by dppp - Thursday, May 19, 2011 9:00 AM -
0 Votes
Transpose Data in CLR Stored procedure
http://sqlmag.com/t-sql/how-sql-server-clr-and-c-can-solve-common-problemAnswered | 2 Replies | 5657 Views | Created by Hari nhangattiri - Friday, October 5, 2012 2:46 AM | Last reply by Stun Dexim - Friday, July 11, 2014 11:11 PM -
0 Votes
Setting up for developing a CLR Stored procedure
Hi, In VS2012 and VS2013 Ultimate, only SQL Server Database project template is provided instead of SQL CLR stored procedure project.Answered | 1 Replies | 622 Views | Created by j.rumbold - Wednesday, April 30, 2014 8:02 AM | Last reply by Amanda Zhu - Thursday, May 1, 2014 7:43 AM -
0 Votes
Can I create CLR stored procedures in VS2010 Express?
Here pops up a dialog, in the botton of this dialog, choose your Target Framework and click OK.Answered | 5 Replies | 2457 Views | Created by r_miller - Saturday, January 21, 2012 4:49 AM | Last reply by Cor Ligthert - Tuesday, January 24, 2012 7:34 AM -
0 Votes
How to debug SQL CLR Stored procedure?
Hi, I have started to work on SQL CLR project.Answered | 2 Replies | 2183 Views | Created by C Mahone - Wednesday, September 17, 2014 1:22 PM | Last reply by Bob Beauchemin - Friday, September 19, 2014 4:57 PM -
1 Votes
Nullable types in SQL CLR stored procedure parameters
The only way to work around this limitation is to choose to turn off script generation altogether and manually add a new stored procedure to the project ...Answered | 3 Replies | 4365 Views | Created by Andy_T1 - Tuesday, March 12, 2013 5:48 PM | Last reply by psirr-MSFT - Friday, July 18, 2014 10:06 PM -
0 Votes
CLR Stored Procedure Crashes, Restarting Job Fixes it
You can just pass data back to the main body of your CLR procedure that is being executed by a thread created by SQL Server.Answered | 2 Replies | 2430 Views | Created by Abby_s Daddy - Tuesday, June 10, 2014 3:52 AM | Last reply by davidbaxterbrowne - Tuesday, June 10, 2014 9:50 PM -
0 Votes
Problem with stored procedures in entity framework
Hello, Suppose you have a stored proceddure as below: -- ============================================= -- -- ...Answered | 3 Replies | 5516 Views | Created by Ali Kolahdoozan - Sunday, October 17, 2010 5:20 PM | Last reply by Sudheer Kumar - Monday, March 14, 2011 2:45 PM -
0 Votes
CLR Stored procedures : variable number of input paramters?
Hi there, I've just started looking into CLR stored procedures.Answered | 1 Replies | 8659 Views | Created by Metropia - Sunday, November 14, 2010 5:38 PM | Last reply by Bob Beauchemin - Sunday, November 14, 2010 6:44 PM -
1 Votes
Stored Procedure call in entity Framework
I ended up creating a wcf service that provides and operation to call the stored procedure.Answered | 2 Replies | 4461 Views | Created by HarshalSilverlight - Wednesday, September 16, 2009 8:27 PM | Last reply by HarshalSilverlight - Thursday, September 17, 2009 4:30 PM -
0 Votes
CLR procedures
When you deploy a CLR procedure you are deploying whole assemblies.Answered | 1 Replies | 1307 Views | Created by Gourav Verma - Wednesday, September 17, 2014 1:11 PM | Last reply by davidbaxterbrowne - Wednesday, September 17, 2014 2:29 PM -
0 Votes
Parallel execution of CLR procedures
But here's a thing, I'll bet you can compute all 3000 of your categories in a single SQL call for about the same price as a single one, store the results, and just read ...Answered | 2 Replies | 7695 Views | Created by Ralf_from_Europe - Friday, February 11, 2011 8:44 PM | Last reply by Ralf_from_Europe - Wednesday, February 16, 2011 7:47 AM -
0 Votes
CLR procedures
I'm able to deploy my CLR procedures, which include probably close to 2000 lines of code in around 15 seconds.Answered | 2 Replies | 1236 Views | Created by Gourav Verma - Thursday, September 18, 2014 12:14 PM | Last reply by Bob Beauchemin - Thursday, September 18, 2014 6:19 PM - Items 1 to 20 of 1816170 Next ›
No announcements
