Answer Posted / skumar

There are many features introduced.
1. XML data type
2. Synonym
3. Instead of Trigger on indexed views
4. CROSS APPLY
5. INTERSECT and EXCEPT statements
6. CTE (Common Table Expressions)
7. PIVOT and UNPIVOT
8. TRY...CATCH and RAISERROR
9. .NET CLR integration
10. Custom data types
11. New data types like NTEXT,NVARCHAR,NCHAR
12.64 bit platform
13.DDL Triggers
14. New functions like RANK(),DENSE_RANK() and ROW_NUMBER
15. MAX Keyword
16. Table variable

What is difference between views and tables?

1006

---

How to transfer an existing table from one schema to another schema in ms sql server?

979

---

How do you use a subquery to find records that exist in one table and do not exist in another?

1045

---

what is the system function to get the current user's user id? : Sql server database administration

1010

---

What is named query? : sql server analysis services, ssas

958

---

Why use “in” clause in sql server?

1071

---

Explain the stored procedure?

1043

---

How to select all columns of all rows from a table with a select statement in ms sql server?

1109

---

How many levels of sp nesting are possible?

1016

---

What is Extended user-defined?

955

---

What is the default sql server instance name?

1030

---

Write query to return all rows sql?

1049

---

What is a select query statement in ms sql server?

1071

---

Where can you find the error log information? : sql server database administration

1022

---

How to sort the query output with order by clauses in ms sql server?

1031

---