What is difference between views and stored procedures?

1 Answers  

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1 Answers  

---

What is the use of for clause?

1 Answers  

---

What is openrowset sql server?

1 Answers  

---

What is sql server locking?

1 Answers  

---

role of sql sever 2005 in database rather than any other database

1 Answers  

---

What is bit data type? What's the information that can be stored inside a bit column?

1 Answers  

---

How many partitions a clustered index has by default in sql server 2012?

1 Answers  

---

What are the difference between clustered and a non-clustered index?

1 Answers  

---

Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,

---

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  

---

How do you drop an index?

1 Answers  

---