No announcements
Found 3282929 threads
-
0 Votes
How to display output "errors" of stored procedure
But when I press the button to execute the stored procedure and if there's a bug it closes the debugger showing me the error inside the Visual Studio.Answered | 5 Replies | 2296 Views | Created by rushelp - Thursday, August 9, 2012 1:21 AM | Last reply by ziman01 - Tuesday, August 14, 2012 9:49 AM -
4 Votes
merge the output of two stored procedures
Declare one table variable for Stored Procedure 1 2.Answered | 9 Replies | 23292 Views | Created by tsk238 - Thursday, August 26, 2010 1:50 PM | Last reply by swat3003 - Thursday, December 20, 2012 5:12 AM -
1 Votes
Error when executing a stored procedure with output parameters
In a my pkg I have used an execute sql task to call a stored procedure in this manner: DECLARE @CountRec as int DECLARE @NameFile as ...Answered | 2 Replies | 4669 Views | Created by pscorca - Wednesday, November 18, 2009 5:18 PM | Last reply by Nitesh Rai - Wednesday, November 18, 2009 5:46 PM -
0 Votes
RAISERROR throwing error from my store procedure
There are differences in nuances.Answered | 11 Replies | 915 Views | Created by Sudip_inn - Wednesday, June 26, 2019 3:24 PM | Last reply by Yitzhak Khabinsky - Friday, June 28, 2019 8:04 PM -
3 Votes
Stored Procedure Output parameter
Thank you, fixing my store procedure fixed it.Answered | 6 Replies | 2920 Views | Created by Nonabona - Tuesday, October 7, 2014 2:25 PM | Last reply by Nonabona - Tuesday, October 7, 2014 3:52 PM -
1 Votes
importance of OUTPUT in Stored procedure
See the difference between return code and OUTPUT parameter.Answered | 3 Replies | 1348 Views | Created by chelseasadhu - Saturday, August 9, 2014 8:21 AM | Last reply by Kalman Toth - Saturday, August 9, 2014 3:40 PM -
1 Votes
Stored procedure data output
As you already invested some efforts developing stored procedure it may be reasonable just to add logging functions into the procedure.Answered | 3 Replies | 1663 Views | Created by mynameismasel - Tuesday, December 18, 2012 7:44 AM | Last reply by SergNL - Tuesday, December 18, 2012 8:28 AM -
0 Votes
C# - Stored Procedure with Output throws two SqlException different errors when attempting to fix
User-2057865890 posted Hi Tom_Befrugal, The first error message tells you that the SQL procedure expect a number of parameters and that the ...Unanswered | 4 Replies | 152 Views | Created by Anonymous - Thursday, March 2, 2017 6:35 PM | Last reply by Anonymous - Wednesday, March 8, 2017 1:31 PM -
3 Votes
Store procedure truncates the output
I can see a stored procedure where you have defined @PopUpImage as nvarchar(max) but not shown the code/ table definition where that value is pulled from.Answered | 4 Replies | 4392 Views | Created by MHNDS - Sunday, April 15, 2012 1:56 AM | Last reply by Seth Lynch - Tuesday, April 17, 2012 9:02 AM -
1 Votes
how to reuse the different set of stored procedure code for single ssis package to two different output flat file destinations.
This article describes how to handle multiple result sets in a script ...Answered | 4 Replies | 2254 Views | Created by Lakshmi S _AP - Tuesday, September 11, 2012 5:53 AM | Last reply by Joon84 - Tuesday, September 11, 2012 8:17 AM -
8 Votes
Stored Procedure, when to use Output paramemter vs Return variable
Or did the people whose answers you copied and pasted without attribution, from your sockpuppet reposting of this question on Stack Overflow ...Answered | 10 Replies | 15291 Views | Created by DoolinDalton - Tuesday, September 28, 2010 5:34 PM | Last reply by Asken12345 - Monday, October 4, 2010 7:30 AM -
0 Votes
Parameter Mapping Output on Stored Procedure
I tried a few different data types and then when I went back to long, it worked fine.Answered | 4 Replies | 699 Views | Created by DanHaf - Tuesday, June 6, 2017 1:06 PM | Last reply by Pirlo Zhang - Thursday, June 8, 2017 1:36 AM -
0 Votes
SqlException: Timeout expired error
The error is only cast on one specific table.Answered | 3 Replies | 9786 Views | Created by Sojborg - Wednesday, May 12, 2010 11:30 AM | Last reply by JuneT - Wednesday, May 26, 2010 10:53 AM -
9 Votes
Stored Procedure with an Output Variable for other Insert Queries
Have you fixed your stored procedure also?Answered | 28 Replies | 8964 Views | Created by tnswalker - Wednesday, December 12, 2012 3:32 PM | Last reply by Naomi N - Thursday, December 13, 2012 8:40 PM -
2 Votes
RAISERROR not causing SqlException
-- 1st result SELECT something -- 2nd result RAISERROR('Error message', 16, 1) -- returnValue OUTPUT parameter RETURN ...Answered | 6 Replies | 21643 Views | Created by Graham Hay - Tuesday, May 17, 2005 3:12 PM | Last reply by PetrKuzel - Wednesday, June 16, 2010 9:57 AM -
3 Votes
Difference between Stored Procedure and extended Stored Procedure
http://www.nullskull.com/q/10014003/tell-me-the-difference-between-stored-procedure-and-extended-stored-procedure.aspx https: ...Answered | 4 Replies | 1430 Views | Created by MU DBA - Wednesday, August 8, 2018 11:18 AM | Last reply by Erland Sommarskog - Wednesday, August 8, 2018 9:48 PM -
0 Votes
Stored procedure giving different output for static database
Hi Uri , below code was returning different data every time , though data is static .Answered | 4 Replies | 484 Views | Created by A2605 - Thursday, February 8, 2018 12:45 AM | Last reply by TiborK - Thursday, February 8, 2018 10:14 AM -
3 Votes
call stored procedure in C#
You get an illegal cast error.Answered | 9 Replies | 177876 Views | Created by Tryin2Bgood - Thursday, August 10, 2006 7:19 PM | Last reply by navyjax2 - Monday, November 28, 2011 9:14 AM -
1 Votes
Ending a Stored Procedure with an Output Parameter
Also, I suggest to add SET NOCOUNT ON; as the first statement in your stored procedure.Answered | 11 Replies | 4706 Views | Created by Ryan0827 - Friday, June 10, 2011 2:31 PM | Last reply by Naomi N - Friday, June 10, 2011 6:29 PM -
2 Votes
Catch SqlException
The best way is like: using (SqlConnection connection = new SqlConnection(connectionString)) { try { ...Answered | 4 Replies | 1317 Views | Created by harrytu - Friday, July 31, 2015 1:58 PM | Last reply by Berimi - Friday, July 31, 2015 5:09 PM - Items 1 to 20 of 3282929 Next ›
No announcements