Interested to Buy Any Domain ? << Click Here >> for more details...
Can you have a nested transaction?
- 4 Answers
- 11943 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / brahma
Yes,
Begin transaction t1
update <Table_Name> set <col1>=<col1>+50
Begin Transaction t2
delete from <Table_Name> set <col1>=<col1>+100
commit Transaction t2
end transaction t1
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / visala
yes, we can have nested transactions. to know the nest
level use @@trancount
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / swapna
Yes, very much. Check out BEGIN TRAN, COMMIT, ROLLBACK,
SAVE TRAN and @@TRANCOUNT.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ram&saran
It's possible, up to 32 levels of transaction in sql server2005.
begin tran t1
----statements
begin tran t2
----statments
.
.
commit tran t2
commit tran t1
| Is This Answer Correct ? | 1 Yes | 2 No |
Are resultset updatable?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
What command is used to rename the database?
How do you identify a foreign key?
What is query processing?
how to use DTS package in 2000,2005,2008 in sql server
your distribution database is full what will u do
Do you have any idea about the tcl commands?
What are character string data types in ms sql server?
can you any body tell me why are go for the rebuild the master database.what is the reason?
Describe in brief system database.
Explain about SQLOS?
-
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)
