What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  

---

How to defragment indexes with alter index ... Reorganize?

0 Answers  

---

Explain different types of index?

0 Answers  

---

Explain the difference between function and stored procedure?

0 Answers  

---

What is #table in sql server?

0 Answers  

---

---

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 Answers  

---

What is a not null constraint?

0 Answers  

---

what is macro?

5 Answers   Excel, Global Innovation, Wipro,

---

Name three version of sql server 2000 and also their differences?

1 Answers  

---

What is openrowset sql server?

0 Answers  

---

How to filter out duplications in the returning rows in ms sql server?

0 Answers  

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

0 Answers  

---