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 3445Post New AllState SQL Server Interview Questions
how sap is different from other software ?
What is Secondary NameNode in Hadoop HDFS?
Name three insectivorous plants?
Why place tempdb and log on low numbered devices?
What is the difference between link and compile in angular.js?
What are the advantages of c over Perl?
What is ipc 610 620?
What exactly do you mean by serialization?
What is the latest version of scala?
hi friend i have selected in ssc cgle as accountant in audit department. can anyone tell about the work of accountant in audit department?
What is the difference between obj-list, rdb-list?
Tell us why should I choose mosaic 21 applications for my erp solution?
Explain routing in zend framework?
Is map a collection?
Can you further subdivide a plant? If yes into what?