Answer / Ashmita Tiwari

In SQL Server, Common Table Expressions (CTEs) are defined by using a WITH clause. The WITH clause defines a temporary result set that can be referenced later in the same SELECT, INSERT, UPDATE, or DELETE statement. Here's an example:nn```sqlnWITH cte AS(n SELECT column1,n column2n FROM yourTablen)nSELECT * FROM cte

Different Types of Functions ?

2 Answers   Satyam,

---

What are the kinds of subquery?

0 Answers  

---

How to change the password of a login name in ms sql server?

1 Answers  

---

What is unpivot?

1 Answers  

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

1 Answers  

---

How do you create type- insensitive operator?

1 Answers   EXL,

---

How to disconnect from a sql server using mssql_close()?

1 Answers  

---

In what version of sql server were synonyms released?

1 Answers  

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  

---

How to provide login information for a new odbc dsn?

1 Answers  

---

Can truncate be rolled back?

1 Answers  

---

Explain an incremental backup?

1 Answers  

---