Stored Procedure

[lisa626]

I am VERY NEW to SQL coding, I am looking at a previously created stored procedure used in a report, it has the following code in it, can someone give me an idea of what it means or where I can get further info on it??? Does the --in front of the line make it a comment???

--and
--(TICKET_No like '8%' or len(TICKET_No) < 8 or
--TICKET_No = '' or TICKET_No is null)
--get current periods totals for Car

 

[gmmastros]

2 dashes indicate a comment (for the remainder of the line). You can comment a block of code with this...

/*

Any number of lines.

*/

The dashes can go anywhere on the line. I've seen stuff like...

[tt]
Select Field, -- This is a comment
AnotherField -- Another comment
From Table -- This is the table
[/tt]

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[lisa626]

I thought so but just wanted to make sure I was thinkn correctly. THANKS