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 3420Post 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)
How many interrupts are there in 8085?
What does ctrl f5 do in excel?
In Australia what is minimum qualifications if the ship has two Main Engines each engine is 2400HP and each engine has its own shaft and propeller. Rgds_____Robert
Is mongodb faster than mysql?
What is policy?
What port does spark use?
You are the project manager for a top-secret software project for an agency of the United States Government. Your mission, should you choose to accept it, is to complete the project using internal resources. The reason is because getting top secret clearances for contractors takes quite a bit of time and waiting for clearances would jeopardize the implementation date. Your programmers are 80 percent of the way through the programming and testing work when your agency appoints a new executive director. Slowly but surely your programmers are taken off this project and reassigned to the executive director's hot new project. Which of the following type of project ending is this? A. Starvation B. Extinction C. Addition D. Integration
Explain M Var? Which types of problem occurs when reactive power increase at the time of full load of plant and at the time of synchronize of plant?
How is an application exception handling is done using a servlet?
What is cmake in linux?
Why subroutine used in programs?
Give an account of proliferating cells ?
What is db flush?
Can you host your own wordpress website?
what are the major building blocks of cloud architecture?
