Answer / Chaina Khatoon

"Sub-queries in SQL are queries nested within other queries. They can have various properties like Correlated (when the outer query references a table that is being queried in the subquery), Non-Correlated (when there's no reference to the outer query), and Derived Table (a table created on the fly using a SELECT statement)."

What is Trace flag?

1 Answers   Wipro,

---

What do you mean by an execution plan? How would you view it?

1 Answers  

---

Explain what are the restrictions while creating batches in sql server?

1 Answers  

---

How is a full-text index updated?

1 Answers  

---

Give a example to search fr a string in all stored procedure in sql server.

1 Answers  

---

What is query cost in sql server?

1 Answers  

---

How to insert new line characters into strings?

1 Answers  

---

How network traffic be reduced by using the stored procedure?

1 Answers   Accenture,

---

What are extended events in sql server?

1 Answers  

---

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1 Answers   MCN Solutions,

---

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 Answers  

---

What is difference between after and before?

1 Answers  

---