application server is slow what may be the problem

0 Answers   Microsoft,

---

What are the differences between ms sql server & oracle?

0 Answers  

---

What is similarity and difference between truncate and delete in sql?

0 Answers  

---

What is updatable resultset?

0 Answers  

---

How to find the login name linked to a given user name?

0 Answers  

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

---

How to execute stored procedure in select statement sql server?

0 Answers  

---

How many categories of data types used by sql server?

0 Answers  

---

What are the tables in sql?

0 Answers  

---

What is the sql case statement used for?

0 Answers  

---

Explain Active/Active and Active/Passive cluster configurations?

1 Answers  

---

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 Answers   AllState,

---