Count number of lines in all stored procedures in current database

home
database
view story

3 Kicks

Count number of lines in all stored procedures in current database(binaryelves.wordpress.com)

submitted by elfy(230) 3 years, 9 months ago

Microsoft SQL Server 2005 I almost finished my current C# project where I have created a lot of stored procedures. By a lot I mean almost 200 :) (I know it is a personal feeling :)) Few days ago I was just curious how many lines I wrote in my stored procedures. To satisfy my curiosity I wrote T-SQL code which show me the truth ;) Blank lines with just Enter pressed are not counted. Score for my project database is: 142 stored procedures, 9419 lines (most of all 537 lines in one SP)

add a comment |category: Database |Views: 34
Tweet