439 training reviews
20 years in business
Call us on: 01457 858 877
What's new in SQL Server 2005
SQL Server 2005 introduces a couple of nice new functions (we particularly like the RANK function), but is not radically different from its predecessor.
Specific new or changed features in SQL Server 2005 include:
New/changed SQL Server 2005 feature - NEW RANKING FUNCTIONS
You can rank rows, number them and divide them into quartiles, deciles, etc using these natty new functions:
New/changed SQL Server 2005 feature - NEW VARCHAR(MAX) DATA TYPE
BLOBs (binary large objects) are history - you can now work with the much more convenient VARCHAR(MAX) data type, which can take up to 2gb of data:
You can view a full list of changes in recent versions of SQL Server by returning to our main SQL Server version history page.