What extended events?

0 Answers  

---

What are types of subqueries?

0 Answers  

---

How can we delete a table in sql server?

0 Answers  

---

When do you think a developer should use sql server-based cursors?

0 Answers  

---

What are information schema views?

0 Answers  

---

Explain throw statement in sql server 2008?

0 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,

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  

---

What is use of except clause? How it differs from not in clause?

0 Answers  

---

Why we are using the sql language?. What is the purpose of using this?

2 Answers  

---

What to perform pattern match with the like operator?

0 Answers  

---

What is the difference between SQL notification and SQL invalidation?

0 Answers   MindCracker,

---