How to use “drop” keyword in sql server and give an example?

0 Answers  

---

What is difference between process and thread? Explain lazy writer funcationality.

2 Answers   Microsoft,

---

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

0 Answers  

---

What is transact-sql language?

0 Answers  

---

How to a Query to copy data from on table to another table.

6 Answers   Cap Gemini,

---

---

What are the recovery models for a database?

0 Answers  

---

Why is normalisation important?

0 Answers  

---

Explain what you mean by 3 tier architecture.

0 Answers   TCS,

---

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

---

ehat is the default port no of sql 2000?

2 Answers   IBM,

---

Can primary key be null?

0 Answers  

---

Explain “@@rowcount” and “@@error” in sql server?

0 Answers  

---