No announcements
Found 3217226 threads
-
0 VotesPassing parameters to a stored procedure
If you go with the latest suggestion, take a look at this great article explaining how to pass them from C# ...Answered | 4 Replies | 3832 Views | Created by Jona Tec - Tuesday, May 25, 2010 2:02 PM | Last reply by Naomi N - Tuesday, May 25, 2010 3:02 PM
-
0 Votes
Stored Procedure Comparing parameters passed in with Table values
Does not UPDATE statement work as follows: update table1 set name = @name, type = @type, add_date = ISNULL(@add_date, add_date), email = ...Answered | 6 Replies | 4157 Views | Created by David Gutter - Friday, January 4, 2013 10:41 AM | Last reply by eralper - Friday, January 4, 2013 12:24 PM -
0 Votes
ssrs pass parameter values to sql server 2012 stored procedure
Then select values from the drop-down list of the parameters to pass values to the stored procedure when render the report.Answered | 5 Replies | 4981 Views | Created by wendy elizabeth - Thursday, September 25, 2014 5:14 PM | Last reply by BI_Support - Friday, September 26, 2014 4:32 PM -
17 Votes
Passing multi-value parameter in stored procedure ssrs
Even for passing Text value with comma separated in a single value parameter we can use function.Answered | 13 Replies | 136133 Views | Created by spydy2011 - Monday, April 16, 2012 8:24 PM | Last reply by martinitram - Wednesday, March 29, 2017 8:33 AM -
1 Votes
Passing cursor as a parameter to the stored procedure in SQL Server
Why would you even think of such a non-relational, slow approach to SQL?Answered | 3 Replies | 20398 Views | Created by SirIndian - Monday, February 28, 2011 11:37 AM | Last reply by --CELKO-- - Monday, February 28, 2011 8:32 PM -
2 Votes
Parameter pass to Access stored procedure from C#
To make it simple pass only parameter name and value, no need to pass datatype, length and etc.Answered | 7 Replies | 6376 Views | Created by Bobbin Paulose - Saturday, March 10, 2012 5:01 PM | Last reply by Bobbin Paulose - Wednesday, March 14, 2012 10:10 AM -
1 Votes
Passing nulls and uniqueidentifier parameters to stored procedure from C#
A further complication is that the sproc uses dynamic SQL.Answered | 2 Replies | 10108 Views | Created by MeProgrammer - Thursday, September 19, 2013 3:13 PM | Last reply by MeProgrammer - Friday, September 20, 2013 1:07 PM -
6 Votes
How to pass multiple values as a parameter to a stored procedure?
get_product_names error is like, Msg 2715, Level 16, State 3, Procedure TEST_BULKFill, Line 1 Column, parameter, ...Answered | 9 Replies | 5233 Views | Created by ank hit - Thursday, May 24, 2012 1:11 PM | Last reply by ank hit - Thursday, May 24, 2012 4:41 PM -
0 Votes
t-sql passing multiple parameter comma delimited values to a stored procedure
Hi wendy elizabeth, I saw you use splitString function in stored procedure, I think you could try to use below query to see whether it works or ...Answered | 2 Replies | 762 Views | Created by wendy elizabeth - Thursday, June 21, 2018 1:57 PM | Last reply by Zoe Zhi - Friday, June 22, 2018 1:42 AM -
0 Votes
Passing multiple parameters in C# .Net 4.0 to an SQL 2008 Stored Procedure
All of the SQL connection and passing the parameters are in the SQLHelper code.Answered | 2 Replies | 14259 Views | Created by HarleyDude0524 - Wednesday, November 21, 2012 10:14 PM | Last reply by HarleyDude0524 - Wednesday, November 21, 2012 10:40 PM -
0 Votes
How to execute Stored Procedure from Front End without passing values to Optional Parameters(I declared parameters as NULL values) in SQL stored procedure?
Declare a SqlParameter & based on the value for the parameter pass either the value or null like show below.Answered | 2 Replies | 5530 Views | Created by Ramanjaneya.N - Saturday, January 29, 2011 6:02 AM | Last reply by RoninB - Saturday, January 29, 2011 7:15 AM -
0 Votes
Pass parameters to a stored procedure.
Hello, I have an Execute SQL task which calls a stored procedure.Answered | 1 Replies | 4438 Views | Created by OLAPWisdom - Tuesday, August 17, 2010 2:55 PM | Last reply by Sudeep Raj - Tuesday, August 17, 2010 2:59 PM -
0 Votes
MULTIPLE VALUES PASSING TO STORED PROCEDURE
MH Try this - Passing multi-value parameter in stored procedure Shahfaisal Muhammed ...Answered | 4 Replies | 1525 Views | Created by MustafaH - Monday, December 30, 2013 3:51 PM | Last reply by Shahfaisal Muhammed - Monday, December 30, 2013 5:33 PM -
0 Votes
To Pass Multivalue Parameter from SSRS to Stored procedure
Hi there When you pass the parameter to stored procedure the parameter consider as an array not string so you have to do something like that.Answered | 3 Replies | 11414 Views | Created by neel24 - Monday, April 23, 2012 6:11 PM | Last reply by Kalman Toth - Tuesday, April 24, 2012 7:50 PM -
0 Votes
SSRS and passing multiple values from Parameter
Hi Pth184, If we use input parameter procedure when we create data set in SQL Server Business Intelligence Development Studio(BIDS), it will create a ...Answered | 2 Replies | 3722 Views | Created by pth184 - Tuesday, October 9, 2012 4:43 PM | Last reply by Charlie Liao - Thursday, October 11, 2012 6:16 AM -
0 Votes
Pass Multi-Value parameters to Stored Procedure problem
Hi, You can write a SQL function(GETTABLEFROMCSV) which would take the multi-valued parameter as input and would return you a table of individual ...Answered | 9 Replies | 5793 Views | Created by Lasha89 - Wednesday, October 6, 2010 12:16 PM | Last reply by Challen Fu - Tuesday, October 12, 2010 12:05 PM -
1 Votes
Passing a null value to a stored procedure
If the NULL value [sic] is passed to the stored procedure, it does not return any results.Answered | 7 Replies | 838 Views | Created by system243trd - Monday, January 18, 2016 7:23 PM | Last reply by --CELKO-- - Tuesday, January 19, 2016 5:44 PM -
2 Votes
Pass Parameter to SQL Stored Procedure from SharePoint InfoPath Form
I can find no way to call a stored proc and pass parameters without using code.Answered | 3 Replies | 9776 Views | Created by Michael Bratley - Thursday, February 14, 2013 10:28 AM | Last reply by Bill Richardson IFGW - Thursday, July 18, 2013 3:59 PM -
3 Votes
Passing multivalued parameters to stored procedure
I don't think it answers the original question of passing TVP to stored procedure from the report.Answered | 2 Replies | 3566 Views | Created by Arne Olsson - Tuesday, April 24, 2012 6:34 PM | Last reply by Naomi N - Wednesday, April 25, 2012 3:08 AM -
5 Votes
Is it possible to pass TABLE as the output parameter in stored procedure
Is it possible to pass TABLE as the output parameter in stored procedure.Answered | 6 Replies | 37534 Views | Created by luckyforu2006 - Tuesday, August 10, 2010 12:49 PM | Last reply by Erland Sommarskog - Saturday, March 1, 2014 1:18 PM - Items 1 to 20 of 3217226 Next ›
No announcements
