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 3444Post 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 is a Combiner?
How will you conduct risk analysis?
Is equal to string swift?
What is the wavelength of sound in air?
Where is program files located?
Explain the difference between getch() and getche() in c?
In which infotype you perform the assignment to applicant structure?
What are the advantages of object-relational mapping (orm)?
What is the name of c# compiler?
How to get UpdateMode to work for TQuery on a SQL Server 7.0 table?
What is a ledger?
Name an api used for logging in java?
How to use linked server?
Explain about Splunk architecture and various stages?
Name two types of leak detectors and the method of application for each?
