Answer / deepak_shr

A common table expression (CTE) is a temporary result set
that is defined within the execution scope of a single
SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A
CTE is similar to a derived table in that it is not stored
as an object and lasts only for the duration of the query.
Unlike a derived table, a CTE can be self-referencing and
can be referenced multiple times in the same query.

A CTE can be used to:

1. Create a recursive query.

2. Substitute for a view when the general use of a view is
not required; that is, you do not have to store the
definition in metadata.

3. Reference the resulting table multiple times in the same
statement.

4. Enable grouping by a column that is derived from a scalar
subselect, or a function that is either not deterministic or
has external access.

What are wait types?

0 Answers  

---

what is package configuration variable?How to change file name in folder dynamically?Plz help me

1 Answers  

---

Is it possible to update the views? If yes, how, if not, why?

0 Answers  

---

How do you find the number of rows in a table?

7 Answers  

---

What is the native system stored procedure to execute a command against all databases?

0 Answers  

---

What is the difference between having and where clause?

4 Answers  

---

Explain what is the difference between union and union all?

0 Answers  

---

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

0 Answers   TCS,

---

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  

---

Explain comment on transactions?

0 Answers  

---

What is use of dbcc commands?

0 Answers  

---

What are the dmvs?

0 Answers  

---