Comparision of SQL 2000 & 2005

Can any one tell me about the comparision of SQL Server 2000 & SQL Server
2005. Like any website where I can find the enhacement like
1)
SQL Server 2005 :
We can pass the dynamic value of top in the
procedure.
Select Top @.Top from Table
SQL Server 2000 :
We can't you this and for implementing this we
have to make dynamic query.
2) Datatype :
Date in SQL Server 2005
Time in SQL Server 2005
XML in SQL Server 2005
Varchar(8000) in SQL Server 2000
Varchar(MAX) in SQL Server 2005
Can any one let me know like this sort of comparion I can find in which
website?
Thanks
If you install the SQL Server 2005 beta builds Books OnLine, there's a
section that covers "What's New in SQL Server 2005" for various components
including relational engine, TSQL, Replication, Analysis Services,
Management, Security, etc...
You can download the latest beta/Community Tech Preview from
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx
joe.
"Roy" <roy@.hotmail.com> wrote in message
news:%23legtHAjFHA.576@.TK2MSFTNGP15.phx.gbl...
> Can any one tell me about the comparision of SQL Server 2000 & SQL Server
> 2005. Like any website where I can find the enhacement like
> 1)
> SQL Server 2005 :
> We can pass the dynamic value of top in the
> procedure.
> Select Top @.Top from Table
> SQL Server 2000 :
> We can't you this and for implementing this we
> have to make dynamic query.
>
> 2) Datatype :
> Date in SQL Server 2005
> Time in SQL Server 2005
> XML in SQL Server 2005
> Varchar(8000) in SQL Server 2000
> Varchar(MAX) in SQL Server 2005
>
> Can any one let me know like this sort of comparion I can find in which
> website?
> Thanks
>
>
>