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.

Comment,Datatypes are unlimited

0 Answers   IBM,

---

How to turn on the mssql api module in php?

0 Answers  

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

How to list all triggers in the database with sys.triggers in ms sql server?

0 Answers  

---

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

what is a check constraint?

0 Answers  

---

WHAT OPERATOR PERFORMS PATTERN MATCHING?

2 Answers   CarrizalSoft Technologies, CTS,

---

Please illustrate physical database architecture? : SQL Server Architecture

0 Answers  

---

How do you simulate a deadlock for testing purposes

1 Answers  

---

What the difference between UNION and UNIONALL?

0 Answers   HCL,

---

Explain various data region available in ssrs with their use?

0 Answers  

---