>Hello All!
>
>I recently started working with SQL Server and I have a few questions that I was wondering if anyone could please help me. Thanks ahead of time!
>
>1: Does SQL 2000 have a DATE data type?No but it has DateTime and SmallDateTime data types
>2: Is there a limit to Foreign Keys in a table?Yes, it's 253. See
Maximum Capacity Specifications in BOL.
>3: Where can I find information about features of SQL 2000 and how to use them?The Sql Server Books online (BOL) that come with Sql Server are quite good as a reference. You can go to
http://www.amazon.com and search for "SQL Server 2000" in books section.
--sb--