Answers

Question and Answer:

  Home  Basic SQL Server

⟩ Explain 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

 188 views

More Questions for you: