Answer Posted / visala
yes, we can have nested transactions. to know the nest
level use @@trancount
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to use subqueries with the in operators in ms sql server?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is a bit datatype?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
How to rebuild master databse?
What are the difference between clustered and a non-clustered index?
What is difference between views and stored procedures?
How to convert character strings into numeric values?
What happens if null values are involved in boolean operations?
please differentiate between delete and truncate?
What are the advantages to use stored procedures?
What kind of problems occurs if we do not implement proper locking strategy?
What is a file group?
Explain having clause?