MSSQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the INSERT statement in MSSQL?

How do you insert multiple rows into a table in MSSQL?

What is the basic syntax for the INSERT INTO SELECT statement in MSSQL?

How do you handle NULL values when using the INSERT statement in MSSQL?

How do you use the OUTPUT clause with the INSERT statement in MSSQL?

How do you insert data into a table with an identity column in MSSQL?

How do you use the INSERT INTO ... EXEC statement in MSSQL?

How can you handle errors during an INSERT operation in MSSQL?

How do you insert data into a table from another table with transformations in MSSQL?

Explain a scenario where using the INSERT statement with transactions is crucial in MSSQL and describe how you would implement it.