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 3494Post 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)
Define a process flow diagram?
What is jquery a client or server scripting?
Explain about the Optimizer values passed in Oracle?
Explain the concept of auto wiring.
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
How we can enable hooks in codeigniter?
what has the greater market share of Linux SW/HW?
What is mode in xslt?
How the even routing method works in silverlight?
How to get the debug log of connection user in salesforce to salesforce integration?
Can I reorder the tabs?
How software program for private equity is helpful?
Can select statements be used on views in ms sql server?
What are form input html tags?
How will you serve our bank: as a leader or as a manager?
