Just Learned - Parsing and validating a TSQL query without executing it

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Just Learned

A collection of quick technology learning tips from what people around you learn every day


	Submit a tip


	Subscribe..

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

Parsing and validating a TSQL query without executing it

Dec 2 2012 12:00AM by Alpesh Patel

There are 2 Set Options available to only parse the SQL Statements.

SET PARSEONLY ON; GO SELECT * FROM TableName; GO SET PARSEONLY OFF; GO

SET NOEXEC ON; GO SELECT * FROM TableName; GO SET NOEXEC OFF

Option only give schema of Table.

SET FMTONLY ON; GO SELECT * FROM TableName; GO SET FMTONLY OFF; GO

Read More.. [32134 clicks]

Published under: SQL Server Tips · TSQL Tips · DBA Tips · ·

Previous: How to unhide Formula Bar in Excel 2013
Next: SQL Server - Difference between sp_who and sp_who2

Alpesh Patel

36 · 5% · 1663

Liked

Knew

Learned

Incorrect

Interesting

Forgotten


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it


	Submit

Your Comment

Sign Up or Login to post a comment.

"Parsing and validating a TSQL query without executing it" rated 5 out of 5 by 3 readers

Parsing and validating a TSQL query without executing it

Your Comment