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 the events recorded in a transaction log?

0 Answers  

---

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 Answers  

---

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

16 Answers   Accenture, IBM, Marlabs,

---

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,

---

What are group functions in query statements in ms sql server?

0 Answers  

---

What are character string data types in ms sql server?

0 Answers  

---

What does it mean to manipulate data?

0 Answers  

---

Can primary key be null?

0 Answers  

---

Define left outer join?

0 Answers  

---

Explain the difference between control flow and data flow?

0 Answers  

---

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

---

how to implement locking in sql server

3 Answers   Satyam,

---