A query is a single SQL DML statement, and a batch is a collection of one or more T-SQL statements. The entire collection is send to SQL Server from the front – end application as a single unit of code.
SQL Server parses the entire batch as a unit. Any syntax error will cause the entire batch to fail, meaning that none of the batch will be executed. However, the parsing does not check any object names of schemas because a schema may change by the time the statement is executed.
No comments:
Post a Comment