validating a query before executing.

• koti Reddy.Gurram

  SSC Veteran

  Points: 285

  More actions

  September 6, 2004 at 2:28 am

  #63421

  How can I validate a query before executing the query. I want to simulate the "Parse Query" option of Query Analyzer

• Julian Kuiters

  SSCertifiable

  Points: 6585

  More actions

  September 7, 2004 at 12:12 am

  #521914

  SET PARSEONLY  ON

  When SET PARSEONLY is ON, Microsoft® SQL Server™ only parses the statement but does nto execute it.

  The setting of SET PARSEONLY is set at parse time and not at execute or run time.

  Do not use PARSEONLY in a stored procedure or a trigger. SET PARSEONLY returns offsets if the OFFSETS option is ON and no errors occur.

  ---

  Julian Kuiters
  juliankuiters.id.au