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 different types of data sources?

0 Answers  

---

Explain the cursor lock types?

0 Answers  

---

How can we check the sql server version?

0 Answers  

---

Explain left outer join and right outer join?

0 Answers  

---

in the physical file layout, where should the transaction log be stored in relation to the data file?

0 Answers  

---

how many type of subquery?

2 Answers  

---

Differentiate between mongodb vs. Sql server?

0 Answers  

---

Explain the steps to use transact-sql cursor?

0 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

What are the transaction properties?

0 Answers  

---

Which sql server is best?

0 Answers  

---

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

0 Answers   MCN Solutions,

---