SQL Database Concepts Question:
Download Job Interview Questions and Answers PDF
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
Download Basic SQL Server Interview Questions And Answers
PDF
| 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? |