Explain different isolation levels?

4 Answers  

---

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

---

What does this statement do @@rowcount?

0 Answers  

---

How would you Update the rows which are divisible by 10, given a set of numbers in column?

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

---

How to store and query spatial data?

0 Answers  

---

What is a result set object returned by odbc_exec()?

0 Answers  

---

Does partitioning improve performance sql server?

0 Answers  

---

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

---

How can you get @@error and @@rowcount at the same time?

9 Answers  

---

How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  

---

how can you attach more than 20 ldf files in sql server

0 Answers   IBM,

---