No announcements
Found 4099548 threads
-
0 VotesC# - Stored Procedure with Output throws two SqlException different errors when attempting to fix
https://support.microsoft.com/en-us/help/321903/how-to-returnUnanswered | 4 Replies | 52 Views | Created by Anonymous - Thursday, March 2, 2017 6:35 PM | Last reply by Anonymous - Wednesday, March 8, 2017 1:31 PM
-
0 Votes
Stored Procedure throws primary key violation errors
You get PK violations, because apparently you have multiple threads trying to insert the same data. There is nothing in you stored procedure to prevent this. ...Answered | 6 Replies | 6960 Views | Created by MSDN Student - Friday, March 8, 2013 10:01 AM | Last reply by Junaid_Hassan - Friday, March 8, 2013 10:47 AM -
0 Votes
Stored Procedure with output parameter.
I was wondering how do I add an output parameter to a Stored Procedure that returns a code or string to the calling appAnswered | 1 Replies | 18 Views | Created by Anonymous - Thursday, October 7, 2010 3:08 PM | Last reply by Anonymous - Thursday, October 7, 2010 7:32 PM -
0 Votes
stored procedure with output parameters
calling code, ensure that the parameter is modified to be output xParameter("@NewId").Direction = ...Answered | 3 Replies | 31 Views | Created by Anonymous - Monday, February 11, 2008 5:43 AM | Last reply by Anonymous - Monday, February 11, 2008 9:38 AM -
0 Votes
Stored Procedure with Output parameter..
;@FruitName"].Value.ToString(); } } } reference: #How to return Output parameter from Stored Procedure in ...Answered | 2 Replies | 110 Views | Created by Anonymous - Tuesday, September 27, 2016 8:45 AM | Last reply by Anonymous - Thursday, September 29, 2016 8:30 AM -
0 Votes
Stored procedure output?
Using SMO I can get the input for a stored procedure and by running the stored procedure with arguments that hoperfully produce empty results I can get the ...Answered | 2 Replies | 9282 Views | Created by KevinBurton - Monday, May 21, 2007 12:23 AM | Last reply by KevinBurton - Monday, May 21, 2007 6:40 PM -
0 Votes
How to display output "errors" of stored procedure
I understand. However, when I compile I do not get any errors. But when I press the button to execute the stored procedure and if ...Answered | 5 Replies | 2213 Views | Created by rushelp - Thursday, August 9, 2012 1:21 AM | Last reply by ziman01 - Tuesday, August 14, 2012 9:49 AM -
0 Votes
Stored procedure with output parameter
. Until the reader has been consumed, there is no guarantee that the value for the output parameter will be available (e.g. when calling a SQL Server stored ...Answered | 2 Replies | 4413 Views | Created by sm15455 - Sunday, February 1, 2009 5:58 PM | Last reply by Colin Meek - Monday, February 9, 2009 10:20 PM -
1 Votes
Error when executing a stored procedure with output parameters
@CountRec output, @NameFile output I have created two pkg variables, CountRec as int32 and NameFile as string, and assigned them to the ...Answered | 2 Replies | 4514 Views | Created by pscorca - Wednesday, November 18, 2009 5:18 PM | Last reply by Nitesh Rai - Wednesday, November 18, 2009 5:46 PM -
1 Votes
stored procedure output
Just declare a variable and use the output clause to obtain that value. You can then use it anywhere in the wrapper stored ...Answered | 3 Replies | 4876 Views | Created by boobyy - Thursday, November 12, 2009 5:22 PM | Last reply by njahncke - Thursday, November 12, 2009 6:15 PM -
0 Votes
Multiple errors with stored procedure
User-476482648 posted hello, I am having multiple errors with this stored procedure. The first one is operand type clash: conflict with ...Answered | 4 Replies | 2 Views | Created by Anonymous - Thursday, August 2, 2012 3:54 AM | Last reply by Anonymous - Thursday, August 2, 2012 5:00 AM -
0 Votes
Stored Procedure with OUTPUT parameter
I don't see anything wrong with that. When I run ALTER PROCEDURE ...Answered | 3 Replies | 911 Views | Created by gk1393 - Monday, November 4, 2013 4:11 PM | Last reply by Tom Cooper - Monday, November 4, 2013 4:24 PM -
0 Votes
Executing stored procedure with resultset and output parameter from C#
it is working When i triedAnswered | 1 Replies | 93 Views | Created by Anonymous - Thursday, June 16, 2016 3:43 AM | Last reply by Anonymous - Thursday, June 16, 2016 6:28 AM -
0 Votes
stored procedure with c#
User-1537630096 posted Hi how to execute a stored procedure in c#,following is my code for clicking on pay button. there are ...Answered | 5 Replies | 21 Views | Created by Anonymous - Thursday, October 6, 2011 6:22 AM | Last reply by Anonymous - Thursday, October 6, 2011 7:05 AM -
0 Votes
Stored Procedure & Output parameter
Insert() method. When I test the procedure in Query Analyzer, it works fine and returns the correct value. Any suggestions? Don't I need ...Answered | 2 Replies | 29 Views | Created by Anonymous - Sunday, February 3, 2008 4:32 PM | Last reply by Anonymous - Sunday, February 3, 2008 4:59 PM -
0 Votes
parsing output of xp_msver stored procedure; C#
via SMSS as well. One of the notes on using C# is that you have to be able to tell it in the input parameter type (var char, int or whatever) that the ...Answered | 2 Replies | 6 Views | Created by Anonymous - Tuesday, September 29, 2009 6:10 PM | Last reply by Anonymous - Tuesday, September 29, 2009 8:24 PM -
0 Votes
Replay Provider Error when using stored procedure with xml output
Hi, I'm trying to replay a trace I captured in Profiler. One of the stored procedures traced has an xml output column. When replaying ...Answered | 1 Replies | 4402 Views | Created by SQLAgentMan26 - Friday, August 19, 2011 3:33 PM | Last reply by Kalman Toth - Sunday, August 21, 2011 2:40 PM -
0 Votes
Reading Stored Procedure Output
Ha! Even better. You can just put SET FMTONLY OFF at the beginning of the procedure and it should work. The OLE DB Source is setting SET FMTONLY ON ...Answered | 9 Replies | 5525 Views | Created by Sam K - Tuesday, April 17, 2007 10:00 AM | Last reply by JayH - Wednesday, April 18, 2007 2:02 AM -
0 Votes
Stored Procedure Output Parameter
User833829722 posted I have two stored procedures one generates an output parameter that I then use in the second stored ...Answered | 6 Replies | 15 Views | Created by Anonymous - Sunday, August 19, 2007 4:22 PM | Last reply by Anonymous - Monday, August 20, 2007 12:49 PM -
0 Votes
output stored procedure
int and with this stored procedure: ALTER PROC [dbo].[ShowHierarchy] @Root ...Answered | 7 Replies | 5 Views | Created by Anonymous - Wednesday, October 18, 2006 4:07 PM | Last reply by Anonymous - Saturday, October 21, 2006 8:19 AM - Items 1 to 20 of 4099548 Next ›
No announcements
