No announcements
Found 3334721 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 | 4060 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
Pass parameters to a stored procedure.
Hello, I have an Execute SQL task which calls a stored procedure.Answered | 1 Replies | 4627 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
How to pass Parameters into Trigger in sql server 2005.
Radhey, You cannot pass parameters into a trigger.Answered | 3 Replies | 14172 Views | Created by Radhey Shyam - Monday, June 23, 2008 11:20 AM | Last reply by Ed Price - MSFT - Tuesday, September 25, 2012 10:39 PM -
1 Votes
passing parameters into Triggers.. need help
Hi Pacerier, The two standard methods of pass parameters to triggers are using CONTEXT_INFO or temp table.Answered | 7 Replies | 4567 Views | Created by Pacerier - Saturday, October 30, 2010 9:31 AM | Last reply by Pacerier - Saturday, October 30, 2010 5:19 PM -
4 Votes
How pass optional parameters to stored procedure ?
You stated in your title "how pass optional parameters to stored procedure", so I assumed you knew what they were.Answered | 3 Replies | 21885 Views | Created by Haansi - Thursday, April 23, 2009 4:34 PM | Last reply by David M Morton - Thursday, April 23, 2009 4:58 PM -
0 Votes
how to pass value to the trigger in sql
People say that triggers are hidden stored procedures :-))) so perhaps you want to replace the trigger with a stored procedure?Answered | 2 Replies | 1398 Views | Created by myknowledge - Thursday, January 14, 2016 10:17 AM | Last reply by Uri Dimant - Thursday, January 14, 2016 10:33 AM -
1 Votes
How to pass parameters in WHERE clause from another stored procedure?
I probably should create two datasets in SSRS If you have two parameters for a report, and want the user to select a value from the first parameter, ...Answered | 10 Replies | 2252 Views | Created by Bangaaram - Monday, July 11, 2016 7:34 PM | Last reply by Bangaaram - Wednesday, July 13, 2016 4:23 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 | 3747 Views | Created by Arne Olsson - Tuesday, April 24, 2012 6:34 PM | Last reply by Naomi N - Wednesday, April 25, 2012 3:08 AM -
6 Votes
How to pass multiple values as a parameter to a stored procedure?
It should match the schema of the stored procedure.Answered | 9 Replies | 5404 Views | Created by ank hit - Thursday, May 24, 2012 1:11 PM | Last reply by ank hit - Thursday, May 24, 2012 4:41 PM -
1 Votes
Run Stored Procedure From Trigger
How would I do this?Answered | 8 Replies | 6797 Views | Created by IndigoMontoya - Wednesday, August 17, 2016 1:17 PM | Last reply by Erland Sommarskog - Wednesday, August 17, 2016 9:32 PM -
0 Votes
How to pass a table as parameter of a stored procedure
Then, I create a type from it: create type xxx as table order Does this work?Answered | 3 Replies | 5913 Views | Created by Antony Lai - Thursday, April 15, 2010 2:28 PM | Last reply by TiborK - Saturday, April 17, 2010 5:29 PM -
0 Votes
ado.net how to pass parameter using stored procedure
how to pass two parameter to database from application using stored procedure in ado.net for ex: select * from employee where ...Answered | 2 Replies | 1566 Views | Created by anil bhadke - Wednesday, March 9, 2016 7:24 PM | Last reply by Dave Patrick - Thursday, March 10, 2016 4:20 PM -
0 Votes
pass parameter as table in procedure
I'm wanting to pass the parameter in my stored project to translate as the table name create procedure sdh_DR @version ...Answered | 1 Replies | 966 Views | Created by samuelholder - Wednesday, August 14, 2013 5:45 PM | Last reply by scott_morris-ga - Wednesday, August 14, 2013 6:15 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 | 11666 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
Passing Multivalue parameter to a stored procedure in SSRS
You need to make parameter as long varchar field in the stored procedure say CountryList varchar(5000) Then when you ...Answered | 2 Replies | 3594 Views | Created by Syed Faiz Haider - Monday, January 12, 2015 3:29 AM | Last reply by Visakh16 - Monday, January 12, 2015 4:13 AM -
0 Votes
How to handle Stored Procedure if input parameter is not passed
= '') ..control is going inside begin ..if i don't pass any value to @STRING_Employee_Limit_distribution when executing stored procedure.Answered | 4 Replies | 9512 Views | Created by Sandeep.Handa - Tuesday, November 23, 2010 7:06 AM | Last reply by ramireddy - Tuesday, November 23, 2010 7:31 AM -
0 Votes
How to pass parameter values to the stored procedure dynamically in ssis
You can use execute SQL task and pass the parameters to a stored ...Answered | 4 Replies | 10176 Views | Created by Forum Solution - Sunday, December 9, 2012 2:47 PM | Last reply by Zdenek Nosek - Monday, December 10, 2012 10:09 AM -
2 Votes
Pass array of values from trigger to stored procedure, then cycle through array values in stored procedure
Alternately, and perhaps the easier solution (from my perspective as far as modifying the stored procedure is concerned), is there a way to cycle through the records in the Inserted ...Answered | 2 Replies | 1695 Views | Created by jessman37 - Wednesday, January 15, 2014 8:24 PM | Last reply by Erland Sommarskog - Wednesday, January 15, 2014 11:15 PM -
0 Votes
how to create a procedure to pass parameters to a foreign website
We just use a private software application that creates scripts but from this scripts i can link to databases, call procedures, do look ups etc...Answered | 5 Replies | 4384 Views | Created by EROD81 - Tuesday, May 18, 2010 4:03 PM | Last reply by Olaf Helper - Wednesday, May 19, 2010 5:17 AM -
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 | 6501 Views | Created by Bobbin Paulose - Saturday, March 10, 2012 5:01 PM | Last reply by Bobbin Paulose - Wednesday, March 14, 2012 10:10 AM - Items 1 to 20 of 3334721 Next ›
No announcements
