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 3533Post 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 do you paste a formula without changing the cell reference?
What is delegatingvariableresolver?
Why use ball valves on Gas pipelines instead of gate & or globe valves...means basic diffrence or use of these valves..how designers knows this type of valve with rating is required...
What are the standard profile options for oracle service contracts?
What are the various ways of hosting a wcf service?
Explain stack unwinding.
difference between hard work and smart work?
What's the difference between 32 and 64 bit?
Define how does a try statement determine which catch clause should be used to handle an exception?
Can you explain the working philosophy of Django?
How will you sort the elements of array in descending order?
What is Hibernate Proxy and how it helps in lazy loading?
Draw a wheatstone bridge circuit showing supply, meter and 3 wire RTD connection
what is advantages and disadvantages of CAT5,CAT5e,CAT6,CAT7,COAXIAL CABLE,FIBER-OPTIC
How to hide the base class functionality in Inheritance?
