Title: get number of rows in a table without using count function                                 If you need copy same format use firefox or chrome or safari but iexplorer not work


Preview of Code
USE AdventureWorks
GO
DECLARE @tablename AS sysname = `Production.Product`;
  
DBCC UPDATEUSAGE (0, @tablename)
    WITH NO_INFOMSGS;
  
SELECT [ROWS]
FROM   SYS.indexes AS IND
       INNER JOIN
       SYS.partitions AS PRT
       ON IND.object_id = PRT.object_id
          AND IND.index_id = PRT.index_id
WHERE  IND.object_id = OBJECT_ID(@tablename)
       AND IND.index_id <= 1;