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  

---

What is SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,

---

What are pages and extents? : SQL Server Architecture

0 Answers  

---

What is a trace frag? Where do we use it?

0 Answers  

---

does physical index sort data

1 Answers  

---

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers  

---

Can you move the resources after pausing the node? : sql server database administration

0 Answers  

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

0 Answers  

---

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

---

wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform

1 Answers   Idea,

---

Can binary strings be used in arithmetical operations?

0 Answers  

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---