The below are the basic differences between SQL 05 and SQL 08.
1.In SQL 2005 we can't encrypt the entire database where as in SQL 2008 we can encrypt entire db.
2.In SQL 2005 there is no backup encryption where as in SQL 2008 backup encryption is introduced
3.In SQL 2005 XML - Data Type is introduced where as in SQL 2008 XML - Data Type is implemented and used.
4.In SQL 2005 LINQ is not there where as in SQL 2008 LINQ is introduced for retrieving multiple types of data.
5.In SQL 2005 there is no table valued parameter concepts where as in SQL 2008 table valued parameter is introduced .
6.In SQL 2005 there is Merge statement concept where as in SQL 2008 Merge statement is introduced .
8.In SQL 2005 date time is introduced for date and time where as in SQL 2008 there were major changes in date time i.e 4 data types are introduced in date time they are DATE, TIME,DATETIMEOFFSET and DATETIME2.
9.In SQL 2005 Data Synchronization is not available where as in SQL 2008 Data Synchronization is introduced
10. In SQL 2005 UDT's were restricted to a maximum of 8 KB where as in SQL 2008 restrictions has been removed for UDT's.
1.In SQL 2005 we can't encrypt the entire database where as in SQL 2008 we can encrypt entire db.
2.In SQL 2005 there is no backup encryption where as in SQL 2008 backup encryption is introduced
3.In SQL 2005 XML - Data Type is introduced where as in SQL 2008 XML - Data Type is implemented and used.
4.In SQL 2005 LINQ is not there where as in SQL 2008 LINQ is introduced for retrieving multiple types of data.
5.In SQL 2005 there is no table valued parameter concepts where as in SQL 2008 table valued parameter is introduced .
6.In SQL 2005 there is Merge statement concept where as in SQL 2008 Merge statement is introduced .
8.In SQL 2005 date time is introduced for date and time where as in SQL 2008 there were major changes in date time i.e 4 data types are introduced in date time they are DATE, TIME,DATETIMEOFFSET and DATETIME2.
9.In SQL 2005 Data Synchronization is not available where as in SQL 2008 Data Synchronization is introduced
10. In SQL 2005 UDT's were restricted to a maximum of 8 KB where as in SQL 2008 restrictions has been removed for UDT's.
No comments:
Post a Comment