SQL Server Performance

1.Select statement

Discussion in 'SQL Server 2005 General Developer Questions' started by priya0123, Mar 23, 2007.

  1. priya0123 New Member

    Hello,

    I want to write sql server 2000 query with numbers...
    like


    1. select * from emp
    2. select * from users
    3. select * from idle


    how is it possible?
    Thanks
  2. Adriaan New Member

    What do you want the numbers to do for you?
  3. khtan New Member

    you want to know the number of records in the table ?

    select count(*) from emp


    KH

Share This Page