How many nested transaction can possible in sql server?
Answers were Sorted based on User's Feedback
Answer / naveen
32 nested transaction can possible in sql server
| Is This Answer Correct ? | 14 Yes | 4 No |
Answer / naveen singh
three type of
(1)Begin
(2)Rollback
(3)commit
| Is This Answer Correct ? | 11 Yes | 25 No |
How to create a ddl trigger using "create trigger" statements?
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks
What are pessimistic lock and optimistic lock?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What is the cartesian product of table?
How can we use ConnectorJ JDBC Driver with MS SQL?
What is the temp table?
What is the default fill factor value?
how to find the second salary?
List some advantages and disadvantages of stored procedure?
What stored by the msdb? : sql server database administration
Explain “row_number()” in sql server with an example?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)