diddydustin
Programmer
Hey guys,
I need to parse a SQL query within a stored procedure to check the syntax and see if it is a valid query. If it isn't, the error will go in an OUTPUT variable. However, I'm having trouble parsing a string within the stored procedure because SET PARSEONLY ON isn't work. It tells me that I can't set it within a stored procedure, and further inspection into MSDN's website reflects this.
Does anyone know a method to parse a string, not execute it, so that I can see if it's valid and return a result?
Thanks
Dustin
I need to parse a SQL query within a stored procedure to check the syntax and see if it is a valid query. If it isn't, the error will go in an OUTPUT variable. However, I'm having trouble parsing a string within the stored procedure because SET PARSEONLY ON isn't work. It tells me that I can't set it within a stored procedure, and further inspection into MSDN's website reflects this.
Does anyone know a method to parse a string, not execute it, so that I can see if it's valid and return a result?
Thanks
Dustin