Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-18 : 09:03:35
|
| R.srinivasan writes "hi SQL Erudites, I have a parameter which goes like this..DECLARE @Code VARCHAR(100)@Code = "'10','11','12'"How do i pass the above parameter to stored procedure ?I tried but in vain.Help me out.Wallops!" |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2002-06-18 : 10:11:59
|
| Try this:@Code = '''10'',''11'',''12'''Basically you would need to use double quotes around each item in the list and then quotes around the entire list. |
 |
|
|
|
|
|
Passing parameter to Stored procedure