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

How to fetch the next row from a cursor with a "fetch" statement?

595

---

What are the differences between sql server and mysql.

534

---

Can we install sql server 2016 on windows 7?

677

---

What is the difference between indexing and hashing?

550

---

How to get the query of a table in sql server?

504

---

---

What are the different types of replication you can set up in sql server?

531

---

How does normalization work?

507

---

What is a mixed extent?

595

---

Where actually sql azure database is hosted?

149

---

What different steps will a sql server developer take to secure sql server?

506

---

What is the use of for clause?

585

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

573

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

554

---

Explain table valued parameters in sql server? Why tvp used?

561

---

What is similarity and difference between truncate and delete in sql?

593

---