Differentiate between sql temp table vs table variable?

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 the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  

---

Can primary key be null?

0 Answers  

---

Can we drop user if user mapped to any logins

1 Answers  

---

Can sql server 2016 run on windows 7?

0 Answers  

---

How to transfer data from a cursor to variables with a "fetch" statement?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

what is the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

---

How can we delete Duplicate row in table?

0 Answers   Wipro,

---

What have included columns when we talk about sql server indexing?

0 Answers  

---