Explain what are sparse columns?

0 Answers  

---

diffrence between Cluster Index and non Cluster Index

3 Answers   Wipro,

---

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

0 Answers  

---

---

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---

What are the advantages of sql stored procedure?

0 Answers  

---

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

---

How to create a dml trigger using create trigger statements?

0 Answers  

---

What is ACID Property of Transaction?

10 Answers  

---

What is an index?

8 Answers   Yardi Software,

---

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---