Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

AllState SQL Server Interview Questions
Questions Answers Views Company eMail

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 2191

Post New AllState SQL Server Interview Questions






Un-Answered Questions

What is the difference between AC and DC injection methods for rotor earth fault protection

1301


What's the best database software for mac?

176


How to assign query results to variables?

271


What is cascading in sql?

53


what are Hetergenious joins ?

1088






Tell us how many tables default wordpress have? Can you name those default wordpress table?

39


What is the purpose of user status in notification? As a consultant what do you recommend to your client on the use of this facility?

205


How do I speed up control property access?

670


What are SAP Business Objects BI 4 reporting tools?

29


‘ C’ PROGRAME TO SHOW THE TYPE OF TRANGLE BY ACCEPTING IT’S LENGTH .

1941


what are the different tools in android?

217


What is pthread_mutex?

177


what is the mechanism of action of local anaesthetics?

1398


Why does java have different data types for integers and floating-point values?

220


why we have to use particular buffer only for dissolution instead of using cheap buffer.

1972