How many nested transaction can possible in sql server?
- 3 Answers
- 9883 Views
- Bank Of America, I also Faced
- E-Mail Answers
Answer Posted / naveen singh
three type of
(1)Begin
(2)Rollback
(3)commit
| Is This Answer Correct ? | 11 Yes | 25 No |
Post New Answer View All Answers
If no size is defined while creating the database, what size will the database have?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What are the recovery models in sql server 2000?
What is the process of indexing?
What is xdr?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Which tcp/ip port does the sql server run on? How can it be changed?
Write a sql query to delete duplicate records from a table called table1
Why union all is faster than union?
What is the difference between drop table and truncate table?
Explain few examples of stored procedure over triggers?
What is xml datatype?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
