Tag: Features

  • SQL Server Features

    SQL Server Features

    Sql Server 2000 : Version 8 Query analyzer & enterprise manager are separate We can create 65535 databases only Datetime datatype used for both date & time Sql Server 2005 : Version 9 Query analyzer & enterprise manager are combined as SSMS XML datatype is introduced We can create max (2^20-1) databases Ranking functions (Row_Number,…