Answer Posted / bhaskar

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

what is isolation level at dead lock?

2100

---

What is the order in which the sql query is executed?

892

---

Can an automatic recovery be initiated by a user?

951

---

What is difference between drop truncate and delete?

1026

---

How to call stored procedure using http soap?

1011

---

Create and insert into temp table in sql server?

987

---

How can you insert null values in a column while inserting the data?

1228

---

Which Model uses the SET concept

944

---

How to create an inline table-valued function?

921

---

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1464

---

Explain the Ways to improve the performance of a sql azure database?

80

---

What is a View ? Can we insert, Update and delete a view?

946

---

What is BCP? When does it used in sql server 2012?

1010

---

What are the disadvantages of using querystrings to send data from one page to another?

950

---

How can you find out which stored procedures are recompiling?

889

---