What is lock escalation? : sql server database administration

0 Answers  

---

Explain “row_number()” in sql server with an example?

0 Answers  

---

What are the different types of join?

0 Answers  

---

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

---

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

---

How to tune a stored procedure?

6 Answers  

---

What is meant by dirty read?

0 Answers  

---

What is difference between temp table and cte?

0 Answers  

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,

---

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

13 Answers   Patni,

---

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,

---