WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

4 Answers   CarrizalSoft Technologies, L&T,

---

To find second largest salary in Employee table

17 Answers   CSS,

---

What are the two types of concurrency?

4 Answers  

---

What is a with(nolock)?

0 Answers  

---

what is a transaction and what are acid properties? : Sql server database administration

0 Answers  

---

How to truncate the log in sql server 2012? : sql server database administration

0 Answers  

---

What is a transact-sql statement batch in ms sql server?

0 Answers  

---

What is a raid and what are different types of raid configurations?

0 Answers  

---

what is the difference between a primary key and a unique key? : Sql server database administration

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,

---

How to loop through result set objects using mssql_fetch_array()?

0 Answers  

---

Can anybody explain me cold backup and hot backup?

3 Answers   TCS,

---