Differentiate between a local and a global temporary table?

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 is a Stored Procedure?

8 Answers  

---

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

---

Which system tables contain information on privileges granted and privileges obtained

1 Answers  

---

Explain what are magic tables in sql server?

0 Answers  

---

What is a result set object returned by odbc_exec()?

0 Answers  

---

how to use DTS package in 2000,2005,2008 in sql server

0 Answers   Microsoft,

---

How will u find the query which is running in some other machine

4 Answers   CarrizalSoft Technologies, IBM,

---

Explain differentiate between a having clause and a where clause?

0 Answers  

---

If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,

---

How to drop an existing user defined function in ms sql server?

0 Answers  

---