Analyze SQL syntax

• u.marzo

  Valued Member

  Points: 68

  More actions

  April 8, 2009 at 1:54 am

  #132913

  I have an application where user can set parameters using SQL commands (ie. select param1 where...).

  I need to analyze that sql string to be sure the syntax is correct.

  Is there a stored able to analyze syntax?

  thank in advance.

  u.marzo

• arun.sas

  SSChampion

  Points: 11831

  More actions

  April 8, 2009 at 4:23 am

  #974128

  Hi,

  Use the

  SET PARSEONLY (ON | OFF) to check

  ARUN SAS

  🙂

• u.marzo

  Valued Member

  Points: 68

  More actions

  April 8, 2009 at 6:21 am

  #974202

  Searching for parseonly I found the following thread that solves the question.

  http://www.sqlservercentral.com/Forums/Topic357531-8-1.aspx

  thanks all.

  u.marzo