Answer / cla

A query execution plan outlines how the SQL Server query optimizer actually ran or possibly run a query

How many types of cursors are there in SQL Server?

5 Answers   247Customer, CarrizalSoft Technologies,

---

What will be the maximum number of index per table?

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

What is the default order of an order by clause?

0 Answers  

---

What are the 7 disadvantages to a manual system?

0 Answers  

---

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

What triggers long term care?

0 Answers  

---

What are the different subsets of sql?

0 Answers  

---

What is the distinction amongst delete and truncate?

0 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

---

Which command displays the SQL command in the SQL buffer, and then executes it?

3 Answers   TCS,

---