Interested to Buy Any Domain ? << Click Here >> for more details...
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 3340Post 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)
What does delete function do in perl?
Explain semmap?
Why is frameset not supported html5?
What is the difference between HTML5 interaction in Sencha and Twitter/Bootstrap?
Difference between concurrent hashmap and hashtable and collections
What is mail merge in ms word?
What are some of the options available to transfer materials from one plant to another?
What is difference between ms office and ms word?
What are the different datatypes in tableau?
what is master-detail relationship?
Discuss advantage of different types of screw.
Write a program in c to replace any vowel in a string with z?
Difference between Call by pointer and by reference.
Is reference counting garbage collection?
Where is excel exe located?
