how to exclude commented line text in finding procedure with text in sql server

Question

how to exclude commented line text in finding procedure with text in sql server

Michael Mikhail 0

I'm trying to find all hard code in SPs and Functions in database that containg all possibilities from below:

Application = 1
Application =1
Application= 1
Application=1

can I search for that but without results from commented lines ?

1 answer

Your answer

Answer 1

Erland Sommarskog 120.2K MVP

That is not a trivial operation, as the code has to be parsed.

As it happens, I have a tool to do read source code strip of the comments, write it back to the database, and then bulid a full-text index on the comment-less code. But the tool is part of a larger toolset, so you may find it hard to get started.

The toolset is AbaPerls, which you find here: https://www.sommarskog.se/AbaPerls/index.html. The specific tool I described above is VCDBLOAD, which you can use without understanding the rest of the toolset. But it may still take some time to get started.

Erland Sommarskog 120.2K Reputation points MVP

2023-03-16T08:10:30.8433333+00:00

Posting just before going to bed, I forgot an important thing: VCDBLOAD does not read the source code from the database, but from TFS (or SourceSafe). And on top of that, it is written in Perl, so it may not be easy for you to adapt it to your needs.

Anyway, on my web site there is an article Where is that Table Used, https://www.sommarskog.se/sqlutil/SearchCode.html. It does not address your exact question, but you may find different ways to address your actual probelm.

Share via

how to exclude commented line text in finding procedure with text in sql server

1 answer

Your answer