What is the use of tempdb? What values does it hold?

0 Answers   Abacus,

---

What is the difference between dataadapter and datareader?

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,

---

What is difference between clustered and non clustered index?

0 Answers  

---

What are the different types of subquery?

0 Answers  

---

how do we insert 100 records at a time in a table without using for loop in database

1 Answers  

---

How can you start sql server in different modes?

0 Answers  

---

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 Answers  

---

Create and insert into temp table in sql server?

0 Answers  

---

Explain triggers?

0 Answers  

---

What is row_number () and partition by in sql server?

0 Answers  

---

What is subquery explain with example?

0 Answers  

---