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 EditionBest VPN app

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

Notes:

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.