Senator Guerra Souty original series calendar,replica hublot blue steel peach pointer collocation of rolex replica Rome digital scale, track type minute replica watches scale shows that the classical model is swiss replica watches incomparable, wearing elegant dress highlights.
mr-ponna.com

 

YOU ARE HERE: HOME Questions Difference between sql server 2000 and sql server 2005

SQL Server 2000 vs SQL Server 2005?

 View(s): 10985

Difference between sql server 2000 and sql server 2005?

Answer 1)
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 server 2000 Extended Stored procedures are modified into CLR Stored procedures in sql server 2005.
  Asked in:  Mahindra Satyam   Expertise Level:  Experienced
  Last updated on Saturday, 30 April 2011
4/5 stars (5 vote(s))

Register Login Ask Us Write to Us Help