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-01-15 : 14:56:11
|
| Jagannathan writes "I am using sp_executesql in a stored procedure to execute a dynamic SQL statement. Is there any way to actually parse the validity of the SQL statement without executing it ?ThanksJagan" |
|
|
sica
Posting Yak Master
143 Posts |
Posted - 2002-01-15 : 16:20:01
|
| I'm not aware of such a thing,but you could try with an exists statement the dynamic sql statement you want to execute..Sica |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-01-18 : 14:48:11
|
| If you want to consistently parse rather than execute the statement, then I don't know. BUT, if you are just in debug mode and want to parse it for review, then try printing the statement rather than executing it, you could then copy the results of your print into QA and parse it there.--------------------------------There's a new General in town... |
|
|
|
|
|
|
Parse a dynamic SQL without executing it