Differences between sqlserver 2000 and sqlserver 7.0

Hi Friends,

Can some please let me know the differences between sqlserver 2000 and sqlserver 7.0

The most important two are in SQL Server 2000 DRI(declarative referential integrity) is built in and Unicode collation in down to column level and no need to reinstall to enable Unicode collation. There is the limited implementation of XML and the query processor was improved to correct some join operations returning wrong data. The differences between SQL Server 7.0 and 2000 are minor, major changes are between SQL Server 6.5 and 7.0 and SQL Server 2000 and 2005. Run a search for what is new in SQL Server 2000 BOL(books online). Hope this helps.