SQL Database Concepts Question:
Explain what are the restrictions while creating batches in SQL Server?
Answer:
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
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
| Previous Question | Next Question |
| Explain what are Magic tables in SQL Server? | Do you know what is difference between stored procedure and user defined function? |