Answer Posted / anish nama

Sql server 2005 New features:
1.Datatype varchar(max),XML datatype
2.OUTPUT Clause
3.APPLY OPERATOR
4. PIVOT and UNPIVOT?
A Pivot Table can automatically sort, count, and total the
data stored in one table or spreadsheet and create a second
table displaying the summarized data. The PIVOT operator
turns the values of a specified column into column names,
effectively rotating a table.

5.Tools and utilities
Data types
T-SQL enhancements
Programmability enhancements
XML support
Native XML web services
SQL Management Objects
SQL Server Integration Services
SQL Server Reporting Services
SQL Server Notification Services
SQL Server Service Broker
Replication Management Objects
SQL Server Agent
SQL Server Mobile Edition
The code used in the book is available

In sql server2000 Extended Stored procedures , and it
modified it into CLR Stored procedures

Which are the new data types introduced in sql server 2008?

512

---

Can you insert NULL in unique column?

627

---

What is page-level compression?

553

---

How can delete duplicate records in cte in sql server?

518

---

What does truncate do?

531

---

---

What is the difference between cartesian product and cross join?

480

---

Explain about builtinadministrator?

593

---

Differentiate between ms sql server reporting services vs crystal reports?

487

---

What is use of except clause? How does it differ from not in clause?

554

---

How to set database to be single_user in ms sql server?

565

---

How does using a separate hard drive for several database objects improves performance right away?

528

---

How to find which stored procedure is currently running in sql server?

488

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

551

---

how many clustered indexes can be created on a table? : Sql server database administration

566

---

How to list all columns in a table using odbc_columns()?

536

---