SQL Server Performance Forum – Threads Archive

1.Select statement

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

---

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
KH

---

]]>