Differences between Sql server 2005, 2008

Smith

None

2568 Points

74 Posts

Hi,

What are differences between Sql server 2005, 2008?

Views: 8689
Total Answered: 1
Total Marked As Answer: 0
Posted On: 30-Jun-2015 03:14

Share:

Answers

Brian

Moderator

2232 Points

14 Posts

Hi Smith,

These are the main diefferences:

SQL Server 2005	SQL Server 2008
We can not able to encrypt entire database	We can able to encrypt entire database
Does not provide backup encryption	Backup encryption introduced
XML Data type is introduced	XML Data type implemented and used
File stream is not there	File stream is introduced
Merge statement is not included	Merge statement is included
Datetime is used for both date and time	Major changes in datetime:Four datetime datetype introduced-date,time,datetimeoffset, and datetime2
Data synchronization is not included	Data synchronization is included
Table valued paramete is not there	Table valued parameter is introduced