grepTSQL.pl - Greps for TSQL statements in a SQL Script. The search is performed case-insensitively across multiple lines Uses TSQL::SplitStatement to determine what is and is not a statement. In brief, anything that can contain another simpler statement is *NOT* a statement. E.G. CREATE PROCEDURE is not by itself, a complete statement, as it contains other TSQL statements.
1.0.0
grepTSQL.pl -r <regexp>
Specify regular expressions to match (Or-ed together)
Specify regular expressions to exclude (Or-ed together), these are applied after the match expressions
Ded MedVed.
Hopefully none.
Copyright (c) 2013, Ded MedVed. All Rights Reserved. This module is free software. It may be used, redistributed and/or modified under the terms of the Perl Artistic License (see http://www.perl.com/perl/misc/Artistic.html)
To install TSQL::SplitStatement, copy and paste the appropriate command in to your terminal.
cpanm
cpanm TSQL::SplitStatement
CPAN shell
perl -MCPAN -e shell install TSQL::SplitStatement
For more information on module installation, please visit the detailed CPAN module installation guide.