【SQL Server】Count(*) vs Count(1) 区别

http://msdn.microsoft.com/en-us/library/ms175997.aspx

"1" is a non-null expression: so it's the same as COUNT(*). The optimiser recognises it for what is is: trivial.

The same as EXISTS (SELECT * ... or EXISTS (SELECT 1 ...