How to verify an SQL statement in the SQL Pane in SQL server

When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to verify an SQL statement, they should do the next:

C# in Depth, 3rd EditionManaged Windows VPS Hosting

–┬áRight-click in the SQL Pane, and select Verify SQL Syntax from the shortcut menu.


1. SQL Verification can detect some, but not all SQL errors. If a query contains an error not detected during SQL verification, the database will detect the error when developers run the query.

2. Queries that contain parameters cannot be verified.