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! |