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 |
|
zubair
Yak Posting Veteran
67 Posts |
 Posted - 2003-11-13 : 05:32:26
|
| Hi i get a ayntax error when i'm trying to pass a sql string into a stored proc. I'm trying to do the following and i get a syntax error. can anyone tell me what i'm doing wrong. Thanksselect @sql = @sql + ' and (t1.failedMessage = ' + '''' + ' or t1.failedMessage is null) and t1.requestcomplete = 1 ''' |
|
|
zubair
Yak Posting Veteran
67 Posts |
Posted - 2003-11-13 : 05:57:41
|
| its okay. I've answered it myself. posted the answer anyway. (if anyone comes up with a better way then please feel free to expand on it :) Thanksselect @sql = @sql + ' and (t1.failedMessage = ''' + '''''' + ''' or t1.failedMessage is null) and t1.requestComplete = 1 ' |
 |
|
|
|
|
|
sql string problem