In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2
1 2706Post New AllState SQL Server Interview Questions
-
AllState SQL Server Interview Questions (1)
- AllState HR Questions Interview Questions (5)
- AllState SAP Basis Interview Questions (1)
- AllState USA Business Visa B1 Visa Interview Questions (1)
Which factors decide the maximum threads that one should generate per system?
What are the various benefits of using rac architecture?
How do you edit a table in pgadmin?
What is the difference between an orm and an odm?
What is autograph ?
What is the difference between copy and shortcut?
Explain pruning in decision trees.
Is there a way to separate names in excel?
Explain the difference between unlink() and unset()?
what is msl?
For conduction of heat, the instantaneous rate of heat flow is product of three factors. What are these ?
What is data and information explain with example?
Why MySQL is used?
Is there exchange of cells between the mother and the fetus through the placenta?
What is the use of join method?
