Count rows without using count function in SQL Server

Published --