1.Select statement | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

1.Select statement

Hello, I want to write sql server 2000 query with numbers…
1. select * from emp
2. select * from users
3. select * from idle
how is it possible?

What do you want the numbers to do for you?
you want to know the number of records in the table ? select count(*) from emp