Select Statement

SQLServerCentral » Latest topics

Select Statement

Hi

  What is the difference between * and count(1) if we write

select * from table1

Declare @num as integer
select @num = count(1) from table1.

Thanks

more info...