Explain the properties of sub-query in sql server?

0 Answers  

---

Explain what are sparse columns?

0 Answers  

---

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers  

---

find 2nd highest salary of person using cursor concept?

6 Answers   HCL,

---

wat will be the sql query to extract only last 3 records from table supose table hving thousands for records

19 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

What is in place upgrade in sql server?

0 Answers  

---

what are the disadvantages of cursors? : Sql server database administration

0 Answers  

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

---

What type of Index will get created after executing the above statement?

0 Answers  

---

What is the temp table?

0 Answers  

---

What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,

---