Click here to Skip to main content
15,884,099 members

Article Recommendation

Your Name:*
Your Email:*
Your friend's Email:*
The Message text:

Hi!,

This email was created by [MemberName] <[MemberEmail]> who thought you would be interested in the following Article:

"Count Lines of code in a database"
Assuming that a carriage return represents a line of code, this will count the lines of code in a SQL 2008 database:SELECT ROUTINE_NAME,ROUTINE_TYPE,LEN(ROUTINE_DEFINITION )-len(REPLACE(ROUTINE_DEFINITION,CHAR(10),'')) LOCFROM INFORMATION_SCHEMA.ROUTINESCOMPUTE...

CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!

 
Note: the details entered on this page will not be stored or used for any purpose other than for sending this email.