you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

0 Answers  

---

What is query optimization process?

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 is the command used to get the version of sql server?

1 Answers  

---

What are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

---

How can we call UDF(User Define Function) using C# code in ASP.net ?

1 Answers  

---

What is extended stored procedures?

0 Answers  

---

What is an sql server agent?

0 Answers  

---

What is a primary key?

0 Answers  

---

What gets stored inside msdb database?

0 Answers   Abacus,

---

What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,

---

between cast and convert which function would you prefer and why?

0 Answers  

---