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

Explain what are the different index configurations a table can have?

1039

---

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1132

---

What are character string data types in ms sql server?

1144

---

What type of locking occurs during the snapshot generation? : sql server replication

1264

---

Are all views updatable ?

1104

---

How do I find the transaction log size in sql server?

916

---

Which database stores information about replication?

991

---

How can I create a report based on a query? : sql server management studio

976

---

Do you know how to make remote connection in database?

904

---

How to create and drop temp table in sql server?

1003

---

How to execute a sql statement using mssql_query()?

977

---

What is primary key and example?

898

---

What are different types of statement?

946

---

What is sub query and its properties?

919

---

How to reaname table name without using sp_Rename in sql server..?

939

---