No announcements
Found 3239865 threads
-
0 Votes
Returning multiple output parameters
your query as written is attempting to return multiple result sets, not multiple output parameters.Answered | 2 Replies | 5435 Views | Created by Reza Mohamed - Tuesday, March 31, 2009 7:30 PM | Last reply by SubinP - Wednesday, April 1, 2009 5:09 PM -
1 Votes
Procedure with multiple transactions how to set the error message to the output parameter
Please don't use output parameters to signal failure.Answered | 3 Replies | 909 Views | Created by hypeonfire - Monday, August 31, 2015 4:50 AM | Last reply by davidbaxterbrowne - Monday, August 31, 2015 3:24 PM -
0 Votes
How to get return value and output parameters in ODBC
I don't think you can do this, output parameters are sent in the last packet from the server and are not available to the application until SQLMoreResults returns SQL_NO_DATA.Answered | 3 Replies | 5324 Views | Created by kbindlis - Friday, February 10, 2012 1:49 AM | Last reply by kbindlis - Monday, February 13, 2012 7:25 PM -
0 Votes
DAAB how to get multiple output parameters ?
User583989486 posted Hi Haansi, It is when I need to catch 2 output parameters should I do ...Answered | 3 Replies | 55 Views | Created by Anonymous - Monday, May 9, 2011 4:10 AM | Last reply by Anonymous - Wednesday, May 18, 2011 4:00 AM -
1 Votes
How to set Output Parameter and get the value in SSRS(BIDS)?
Of course, myvalue will be repeated on every row, but it will be equal to the output value of parameter @myvalue.Answered | 6 Replies | 11359 Views | Created by Colin.Fu88 - Monday, September 21, 2015 1:20 AM | Last reply by DJAnsc - Wednesday, September 30, 2015 2:46 PM -
2 Votes
ExecuteReader returns null with output parameter?
Multiple rows?Answered | 4 Replies | 10733 Views | Created by SharpDragon - Friday, February 20, 2015 6:48 PM | Last reply by Joel Engineer - Saturday, February 21, 2015 2:15 PM -
0 Votes
can't call SQL function from DAAB (SqlHelper)
Hi Kevin, Here's how i did it: Boolean result = (bool)SqlHelper.ExecuteScalar(ConnectionString.Connection.ConnectionString, ...Answered | 3 Replies | 8808 Views | Created by Mike Otten - Sunday, June 1, 2008 9:08 PM | Last reply by Michael Nady - Monday, September 7, 2009 1:00 PM -
0 Votes
how to get output parameter from DAAB ?
User852864959 posted Thanks MuddasirKhan, Actually I am using way 2 as in this way save many line of codes to be written for declaring parameters. ...Unanswered | 4 Replies | 74 Views | Created by Anonymous - Tuesday, January 12, 2010 3:37 AM | Last reply by Anonymous - Tuesday, January 12, 2010 6:36 AM -
0 Votes
Returning a value as an output parameter
How to Use Stored Procedures in VB-Using Output parameters in stored procedures Data Sets and Data ...Answered | 2 Replies | 954 Views | Created by BlkopalZ28 - Sunday, January 18, 2015 11:20 PM | Last reply by Eric__Zhang - Tuesday, January 20, 2015 1:34 AM -
0 Votes
How To Call OutPut Parameters in Execute SQLTask?
output now in the parameter mapping, set direction: output - parameter name : 0 - variablename : your variable here ....Answered | 12 Replies | 4423 Views | Created by cmk1 - Sunday, July 25, 2010 12:53 AM | Last reply by Reza Raad - Monday, July 26, 2010 5:32 AM -
0 Votes
Impact of output parameter in performance.
There are a lot of variables here: 1) How often do you call this stored procedure?Answered | 1 Replies | 5968 Views | Created by Neo Developer - Friday, September 11, 2009 9:34 AM | Last reply by Dan Benediktson - Friday, September 11, 2009 4:50 PM -
0 Votes
My problem with output parameters
Yes, you can check the value returned by the OUTPUT parameter.Answered | 5 Replies | 2404 Views | Created by Kimi86 - Friday, March 23, 2012 6:20 AM | Last reply by Paresh Patel - Friday, March 23, 2012 9:21 AM -
0 Votes
How to map multiple output values to the output schema in biztalk mapper?
To create a destination canonical schema that works fine, I have to somehow pass this surname value from source schema as parameter so that it uses this value to poll the ...Answered | 4 Replies | 2368 Views | Created by MANIBEST - Thursday, March 6, 2014 5:37 PM | Last reply by Muhammad Ehsan - Friday, March 7, 2014 2:38 PM -
0 Votes
Parameter Output Problem
To access the OUTPUT parameter in your VB.net code you need to do the following - Create a SqlCommand object.Answered | 7 Replies | 4347 Views | Created by CoderRick - Thursday, June 16, 2011 2:06 PM | Last reply by vinaypugalia - Thursday, June 16, 2011 2:57 PM -
1 Votes
How to build dynamic query that needs an output parameter
The trick was that I needed a dynamic sql inside of a dynamic sql (the parameter string passed to ExecuteSQLOnSpecificDBs) .Answered | 4 Replies | 913 Views | Created by TheBrenda - Friday, January 8, 2016 3:25 PM | Last reply by TheBrenda - Friday, January 8, 2016 7:05 PM -
0 Votes
ExecuteDataset and Output parameters in DAAB
I'm using the new Enterprise Library DAAB and attempting to return a dataset AND obtain a value through an output ...Unanswered | 1 Replies | 99 Views | Created by Anonymous - Thursday, June 30, 2005 9:51 PM | Last reply by Anonymous - Thursday, July 14, 2005 9:20 PM -
1 Votes
How to execute stored procedure with output parameters
Sorry to give you bad new but EF does not support output parameters directly.Answered | 6 Replies | 17186 Views | Created by CT3 - Sunday, November 16, 2008 1:16 AM | Last reply by Jonuz - Monday, February 21, 2011 11:22 AM -
0 Votes
How does OUTPUT PARAMETER work with C#, how to understand it correctly?
Hi nickname, Output parameter is the parameter that output the value to a variable or application In First case , you are ...Answered | 3 Replies | 3448 Views | Created by I can't find a nickname - Friday, June 13, 2014 5:14 AM | Last reply by Dan Guzman - Friday, June 13, 2014 12:14 PM -
0 Votes
ADO.NET output parameters to stored proc
The code for the 15 output parameters is exactly the same as the snippet I gave.Answered | 6 Replies | 4504 Views | Created by Krishna Chaithanya - Thursday, January 31, 2013 5:47 PM | Last reply by Bob Shen - Wednesday, February 6, 2013 9:55 AM -
0 Votes
Daab and output parameters
. --------------------------------------------- Yep, if you use ExecuteNonQuery method of SqlHelper, you can just execute and get the .Value of the parameter without having ...Unanswered | 3 Replies | 45 Views | Created by Anonymous - Monday, March 29, 2004 5:10 AM | Last reply by Anonymous - Monday, March 29, 2004 1:27 PM - Items 1 to 20 of 3239865 Next ›
No announcements