No announcements
Found 1770031 threads
-
0 VotesADO.NET output parameters to stored proc
The error is that I'm not able to read the output values.Answered | 6 Replies | 4506 Views | Created by Krishna Chaithanya - Thursday, January 31, 2013 5:47 PM | Last reply by Bob Shen - Wednesday, February 6, 2013 9:55 AM
-
1 Votes
Default Output Parameter Value is Not Returned
Since I am using VB.NET and ADO.NET to talk to my SQL Server stored procedure.Answered | 2 Replies | 10917 Views | Created by Ryan0827 - Tuesday, June 14, 2011 8:36 PM | Last reply by Ryan0827 - Wednesday, June 15, 2011 3:11 PM -
2 Votes
Multi value parameter with stored proc
Hello, In Reporting Services, all selected values of multi-value parameter will be passed as a comma-delimited string when using stored ...Answered | 5 Replies | 4948 Views | Created by anaylor01 - Thursday, November 22, 2012 1:42 AM | Last reply by Fanny Liu - Friday, November 23, 2012 1:13 AM -
0 Votes
Default parameter value
Try deleting the parameters from you report.Answered | 2 Replies | 3762 Views | Created by Nitin Khurana - Tuesday, August 11, 2009 2:49 PM | Last reply by Bryan Boutwell - Tuesday, August 11, 2009 3:33 PM -
0 Votes
ADO.NET execute an oracle stored proc having a parameter of %rowType
ADO.NET has no concept of Oracle's table%rowtype and I don't believe it's supported by ODP.NET.Answered | 1 Replies | 4814 Views | Created by animettion - Tuesday, May 15, 2012 5:20 PM | Last reply by Paul P Clement IV - Wednesday, May 16, 2012 12:44 PM -
0 Votes
Calling Stored Proc - Parameters Issue
The value in the database table is not NULL but just empty.Answered | 7 Replies | 1234 Views | Created by obrienkev - Wednesday, November 28, 2012 11:08 AM | Last reply by obrienkev - Wednesday, November 28, 2012 1:36 PM -
0 Votes
Stored Proc - with XML passed as parameter
> what is the difference between creating Table using Stored Proc and creating Table using SQL Query?Answered | 3 Replies | 666 Views | Created by JaguarsJag - Wednesday, September 21, 2016 4:14 PM | Last reply by Albert_ Zhang - Monday, September 26, 2016 2:37 AM -
2 Votes
Trace value in stored proc
If the event was RPC:Completed, it was a call from the application, and thus the value 12345 was sent from the application.Answered | 2 Replies | 713 Views | Created by WLI863 - Saturday, November 12, 2016 5:16 PM | Last reply by Erland Sommarskog - Sunday, November 13, 2016 12:18 PM -
0 Votes
SSRS Using Optional Parameters with Stored Procs
=Iif(parameterValue = "Value",True,False) or if you just wanted to filter rows based on the parameter values, you could use the filter properties in the ...Answered | 4 Replies | 3888 Views | Created by MCollima - Monday, July 9, 2012 12:33 PM | Last reply by EricHanson - Monday, July 9, 2012 4:31 PM -
0 Votes
Store Proc - Empty Parameter
Hi folks, I have managed to figure it out, if I change the store proc ...Answered | 9 Replies | 1981 Views | Created by brucey54 - Monday, August 18, 2014 9:58 PM | Last reply by brucey54 - Saturday, August 23, 2014 8:50 PM -
0 Votes
OLEDB Source Task Editor Stored Proc with Parameters
I guess you wanted a return value from the stored proc be used in the FF, right?Answered | 19 Replies | 4203 Views | Created by Spunny - Tuesday, April 10, 2012 2:39 PM | Last reply by Spunny - Tuesday, April 10, 2012 7:27 PM -
0 Votes
Need help with stored proc with parameters
In addition to RSing notes, you can see these tutorials: Creating a simple stored procedure Create a Stored ...Answered | 2 Replies | 2682 Views | Created by Techsupport12 - Saturday, September 7, 2013 4:37 PM | Last reply by Saeid Hasani - Saturday, September 7, 2013 6:38 PM -
0 Votes
Default return values of Stored Proc
Unless you use RETURN explicitly in the SP, it will default to 0.Answered | 5 Replies | 2021 Views | Created by Murali_CHN - Wednesday, October 17, 2012 10:40 AM | Last reply by Santhosh H - Wednesday, October 17, 2012 10:57 AM -
4 Votes
Wait for Stored Proc to Complete
Hi, I have code that calls a stored proc.Answered | 6 Replies | 5768 Views | Created by obrienkev - Wednesday, June 6, 2012 11:59 AM | Last reply by Chris Holly - Thursday, June 7, 2012 3:33 PM -
0 Votes
Different default parameter values
Hi mrHh, Per my understanding that you have two date type parameters, you want to change the default values of the two parameters based on if the ...Answered | 4 Replies | 1052 Views | Created by MrHappyHead - Monday, April 13, 2015 9:11 PM | Last reply by MrHappyHead - Tuesday, April 14, 2015 9:26 PM -
0 Votes
Retrieve value from stored proc
Does anybody know whether it is possible to get values from a stored procedure?Answered | 2 Replies | 4400 Views | Created by linkit - Thursday, March 15, 2012 2:19 PM | Last reply by linkit - Monday, March 19, 2012 12:39 PM -
0 Votes
SQL Statement as Parameter for Stored Proc
The default value for a parameter must be constant or NULL.Answered | 8 Replies | 1663 Views | Created by Kirk P. _ - Monday, September 29, 2014 3:28 PM | Last reply by Kirk P. _ - Tuesday, September 30, 2014 2:10 PM -
0 Votes
Execute Store proc for the given values
> I have a very generic store proc that is currently getting executed for single value at a time.Answered | 5 Replies | 849 Views | Created by Priya Bange - Sunday, February 7, 2016 9:45 AM | Last reply by Erland Sommarskog - Monday, February 8, 2016 11:19 AM -
0 Votes
Proc params with defualt values
I think you code looks fine, if you call usp 'herProc' from usp 'MyProc' and only provide 3 parameters while 'herProc' is expecting 4 param values but it will ...Answered | 4 Replies | 2481 Views | Created by WIJ - Tuesday, November 1, 2011 9:25 PM | Last reply by Arbi Baghdanian - Wednesday, November 2, 2011 4:17 PM -
0 Votes
Stored Procedure Parameters - Setting a default value
There is no way to provide default values for certain parameters if you're not using named parameters syntax.Answered | 8 Replies | 4836 Views | Created by TheBrenda - Wednesday, January 8, 2014 4:40 PM | Last reply by TheBrenda - Thursday, January 9, 2014 2:21 PM - Items 1 to 20 of 1770031 Next ›
No announcements
