SQL Server Database Administrator Question:
Download Questions PDF

Can we have a nested transaction?

SQL Server DB Administrator Interview Question
SQL Server DB Administrator Interview Question

Answer:

Yes, very much. Check out BEGIN TRAN, COMMIT, ROLLBACK, SAVE TRAN and @@TRANCOUNT

Download SQL Server DB Administrator Interview Questions And Answers PDF

Previous QuestionNext Question
What is the system function to get the current user's user id?What is the difference in Login Security Modes between v6.5 and 7.0?