What is a virtual table in sql?

0 Answers  

---

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

0 Answers   Crown Solutions,

---

Explain DBCC?

0 Answers   QuestPond,

---

How to execute stored procedure and set temp table in sql server?

0 Answers  

---

What is a performance monitor?

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  

---

What the different types of Replication and why are they used?

0 Answers  

---

What is the difference between index seek vs. Index scan?

0 Answers  

---

How do I connect to sql server database?

0 Answers  

---

Can we use trigger new in before insert?

0 Answers  

---

How to create a simple user defined function in ms sql server?

0 Answers  

---

Define the one-to-one relationship while designing tables.

0 Answers  

---