What are the restrictions while creating batches in SQL Server?CREATE DEFAULT, CREATE PROCEDURE, CREATE RULE, CREATE TRIGGER, and CREATE VIEW statements cannot be combined with other statements in a batch. A batch can't contain altered command and then the new columns referenced command of the same table. The EXECUTE keyword is not required, when an EXECUTE statement is the first statement in a batch
|