No announcements
Found 3962839 threads
-
0 VotesDoes "set nocount on" affect a CLR procedure
Due to my investigations, the behaviour is like this: If a Transact-SQL procedure sets the option "set nocount on" and then ...Answered | 5 Replies | 2546 Views | Created by Christoph Zenger MS Account - Wednesday, November 27, 2013 8:42 AM | Last reply by Christoph Zenger MS Account - Thursday, November 28, 2013 8:20 AM
-
0 Votes
using ent lib, does it mean that stored procedure can never use set nocount on?
User-837620913 posted You can set NOCOUNT on in a stored procedure when using Enterprise Library, it will just return -1 for ...Answered | 1 Replies | 71 Views | Created by Anonymous - Wednesday, August 3, 2011 3:10 AM | Last reply by Anonymous - Wednesday, August 3, 2011 5:15 AM -
2 Votes
Is "SET NOCOUNT ON" global?
No, the "SET NOCOUNT ON" scope is limited to a Stored Procedure, you need not to it SET OFF.Answered | 3 Replies | 4221 Views | Created by Andre aF Ferreira - Thursday, December 22, 2011 9:23 AM | Last reply by Manoj Pandey (manub22) - Thursday, December 22, 2011 9:53 AM -
3 Votes
SET NOCOUNT scope?
I think you meant you always put SET NOCOUNT ON at the top of the SP.Answered | 3 Replies | 6568 Views | Created by scott_m - Thursday, November 29, 2012 4:06 PM | Last reply by Naomi N - Thursday, November 29, 2012 4:16 PM -
1 Votes
"SET NOCOUNT ON" and SqlCommand.ExecuteNonQuery and SQLDataAdapter.Update
SET NOCOUNT ON supresses the DONE_IN_PROC messages returned by the TDS protocol.Answered | 1 Replies | 10508 Views | Created by GKS001 - Wednesday, June 20, 2012 4:30 AM | Last reply by Dan Guzman - Wednesday, June 20, 2012 5:12 AM -
3 Votes
Does SET NOCOUNT ON eliminate @@ROWCOUNT values after table inserts?
Some of the procedures use minimal logging for inserts.Answered | 4 Replies | 2070 Views | Created by SQL Server dude - Friday, May 31, 2013 11:13 PM | Last reply by SQL Server dude - Tuesday, June 4, 2013 5:44 PM -
0 Votes
Can not install stored procedure using sqlcmd
Well I created a single script and copied all stored procedure in it and it worked fine.Answered | 7 Replies | 6668 Views | Created by Maverickcoder - Tuesday, August 10, 2010 3:48 PM | Last reply by Maverickcoder - Tuesday, August 10, 2010 6:55 PM -
0 Votes
Stored Procedures
but what is Nocount on, what does it mean?Answered | 6 Replies | 2803 Views | Created by shivashankara - Wednesday, June 13, 2012 9:23 PM | Last reply by Erland Sommarskog - Wednesday, June 13, 2012 10:00 PM -
0 Votes
sql stored procedure using IN Statement
Noobs never bother to properly design encoding schemes; really hopeless noobs use IDENTITY!Answered | 4 Replies | 1392 Views | Created by bsa - Wednesday, December 25, 2013 8:53 AM | Last reply by --CELKO-- - Wednesday, December 25, 2013 9:54 PM -
0 Votes
SQL Trace to detect SET NOCOUNT OFF
So - can SQL activity from a procedure with SET NOCOUNT OFF be detected via a trace?Answered | 5 Replies | 1421 Views | Created by tgoddard22 - Thursday, December 11, 2014 11:33 PM | Last reply by Dan Guzman - Friday, December 19, 2014 4:48 AM -
1 Votes
Are there any negative affects with: SET NOCOUNT ON
When calling stored procs from .Net you always want to SET NOCOUNT ON.Answered | 7 Replies | 6169 Views | Created by normchan - Tuesday, June 25, 2013 11:41 AM | Last reply by normchan - Saturday, June 29, 2013 7:14 PM -
7 Votes
Use of GO in a Stored Procedure
It's a little confusing because you seem to use DML to mean DDL.Answered | 13 Replies | 77928 Views | Created by Leeroyster - Friday, August 20, 2010 2:35 PM | Last reply by TechVsLife2 - Wednesday, May 30, 2012 10:53 PM -
0 Votes
DataAdapter UpdateCommande using Stored procedure
I have written about it here: ...Answered | 1 Replies | 3930 Views | Created by singhhome - Tuesday, April 7, 2009 10:14 PM | Last reply by Michael Aspengren - MSFT - Wednesday, April 8, 2009 8:57 AM -
0 Votes
IN Operator Parameter using stored procedure
It is not able to pass an array in a stored procedure.Answered | 8 Replies | 22058 Views | Created by Codernater - Wednesday, April 15, 2009 11:17 PM | Last reply by Suman007 - Monday, March 24, 2014 6:53 AM -
0 Votes
Adding values in row using Stored Procedure
Try AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. -- SET ...Answered | 2 Replies | 750 Views | Created by Kenman87 - Tuesday, August 18, 2015 3:00 AM | Last reply by Kenman87 - Tuesday, August 18, 2015 4:01 AM -
1 Votes
Database SET NOCOUNT option.
You can although set it to off at the instance level i.e.Answered | 3 Replies | 2950 Views | Created by techresearch7777777 - Tuesday, February 28, 2017 10:59 PM | Last reply by philfactor - Tuesday, February 28, 2017 11:19 PM -
2 Votes
retrieve data from a stored procedure using powerpivot
Switching NOCOUNT to ON fix this issue Example SET NOCOUNT ON;Answered | 4 Replies | 3022 Views | Created by Onyx101 - Monday, July 14, 2014 12:13 PM | Last reply by Biswa83 - Tuesday, June 19, 2018 2:37 PM -
1 Votes
When to use grouped stored procedure
Not only does it (IMO) serve no useful purpose.Answered | 4 Replies | 1186 Views | Created by Rahul Kumar (Rahul Vairagi) - Wednesday, March 6, 2013 9:59 AM | Last reply by Chuck Pedretti - Wednesday, March 6, 2013 8:19 PM -
6 Votes
Using a trigger to call a stored procedure
So you can use Transperant Data Encryption.Answered | 9 Replies | 29308 Views | Created by Osho27 - Tuesday, January 1, 2013 7:03 PM | Last reply by Erland Sommarskog - Thursday, January 3, 2013 3:21 PM -
0 Votes
DataAdapter SQL InsertCommand using a stored procedure?
Hello, Usually for a INSERT (such as shown below) in a stored procedure is done using a connection and command object for single inserts not a DataAdapter ...Answered | 3 Replies | 954 Views | Created by lkubler - Saturday, April 20, 2019 9:37 PM | Last reply by Kareninstructor - Monday, April 22, 2019 10:48 PM - Items 1 to 20 of 3962839 Next ›
No announcements
