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 3528Post 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 lead body copy in bootstrap?
Explain the mechanism by which you can distinguish between transient (i.e. Newly instantiated) and detached objects in hibernate?
In what service does AWS work?
What is peek in stack?
How many modules are there in spring?
an access path may be in which sequence?
What are the features of selenium ide ?
---------------Describe OLAP Reporting and RDBMS Reporting?
What is same origin policy? How you can avoid same origin policy?
Explain the body decoration?
List the functions of Spark SQL?
What are write off entries to be passed say if im having payable of Rs. 400 standing in the balance sheet and I want to write it off...
What is scheduling in threading?
Compared to your competition, how do you compete with respect to price, features, and performance? - Venture Capitalists
What Are Various Investments Under Section 80(c) Of Income Tax Act?
