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 |
daya88
Starting Member
1 Post |
Posted - 2012-10-25 : 17:02:57
|
Hello,I'm trying to tune a basic query, but I am receiving a "Encountered unexpedted token "?"" error message. An example of the query is : Select * from table a where a.column IN (?,?,?,?,?)orSelect * from table a where a.column=?Would you please explain me what does that "?" do? So I could find a solution for my error.Thank you in advance for your cooperation. |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-25 : 17:08:00
|
soiunds like you're using this query inside execute sql task or oledb command in SSIS.'?' is placeholder for parameters. you need to map appropriate parameters in parameter mapping tab against place holders------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-10-26 : 05:58:17
|
right(str,4)==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|