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 is the difference between commit and rollback?

0 Answers  

---

Which is best Subquery (or) joins in sql server? explain why

2 Answers  

---

What stored by the model? : sql server database administration

0 Answers  

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

0 Answers  

---

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  

---

---

What is stored procedures?

0 Answers  

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

what's the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---

What is the difference between varchar and nvarchar types?

1 Answers  

---

What is clustered vs nonclustered index?

0 Answers  

---

What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,

---

How many instances per computer are there in sql server 2000?

0 Answers  

---