Count(*) vs Count(Id) in sql server 2005

I use SQL COUNT function to get the total number or rows from a table. Is there any difference between the two following statements?

SELECT COUNT(*) FROM Table

and

SELECT COUNT(TableId) FROM Table

Also, is there any difference in terms of performance and execution time?

sql-server-2005 count

Edit Report

0 Answers