Count number of rows in stored procedure

Following code is used to count number of rows in stored procedure.


SELECT
     SP.NAME 'SP NAME',
     SUM((LEN(SC.TEXT) - LEN(REPLACE(SC.TEXT, CHAR(10), '')))) AS 'LOC'
FROM SYS.PROCEDURES SP
     INNER JOIN SYSCOMMENTS SC ON SP.OBJECT_ID=SC.ID
WHERE
     SP.OBJECT_ID=OBJECT_ID('YourSP')
GROUP BY
     SP.NAME

Leave a comment