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 2697Post New AllState SQL Server Interview Questions
What is the purpose of payment methods and when are they stored?
Explain dataproviders in testng ?
What is complexity of bubble sort?
Why isn't any of this standardized in c? Any real program has to do some of these things.
Which respective symbols are used to separate a line and to break the lengthy statement into multiple statements in the vbscript language?
What is the purpose of capacitor?
Explain microarrays. How are they related to dna?
Which nuclear reactor uses water as a coolant, moderator and reflector ?
What do you mean by cardinality and its types?
What is task control?
do you know what is the address formats of the wcf transport schemas? : Wcf data services
Define X++?
what s the standrd size of pvc fittings ,like elbow, bend,tee etc ? please explain with figure ?
What is the purpose of execute method of action class?
What are the different types of reports in peoplesoft?