How many types of subqueries are there in sql server?

0 Answers  

---

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

0 Answers  

---

Can group functions be mixed with non-group selection fields in ms sql server?

0 Answers  

---

Explain the concept of recursive stored procedure.

0 Answers  

---

What is the log shipping?

0 Answers  

---

How to retrieve data from log files in SQL SERVER ?????

1 Answers  

---

Explain atomicity?

0 Answers  

---

Mention the differences between having and where clause.

0 Answers  

---

How to defragment indexes with alter index ... Reorganize?

0 Answers  

---

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,

---

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,

---

Explain where clause?

0 Answers  

---