how to identify the objects that are commented in the procedure

Question

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Tushar Kanti Ten Centuries Points: 1145 More actions · Answer 1

I need to remove the commented part from the string extracted from syscomments.

Ron McCullough SSC Guru Points: 63877 More actions · Answer 2

Lines can be comented by using -- (for a single line of text) or /* */

The @Script holds the text you retrieved from the syscomments entry and is used here to demonstrate the code

Here is some code to handle the -- case

SET @Script = 'DECLARE @S INT /* used to test for comment lines */

-- Another method to comment line

SELECT * FROM logentries'

DECLARE @Pos1 INT

DECLARE @Pos2 INT

SET @Pos1 = 0

SET @Pos2 = 0

SET @Pos1 = CHARINDEX('--',@Script,1)

IF @Pos1 > 0

BEGIN

SET @Pos2 = CHARINDEX(CHAR(10),@Script,@Pos1 + 1) --CHAR(10) = line feed

END

--Follwing code is to demonstrate what was retrieved

SELECT SUBSTRING(@Script,@Pos1,@Pos2 - @Pos1

Result:

-- Another method to comment line

In a similiar fashion you can use /* to find @Pos1 and for @Pos2 use '*/'

instead of CHAR(10)

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Tushar Kanti Ten Centuries Points: 1145 More actions · Answer 3

Ten Centuries

Points: 1145

August 3, 2010 at 10:10 pm

Thanks Ron...

Cookies on SQLServerCentral