Remark in Stored Procedure

  • Thread starter Thread starter Bob Day
  • Start date Start date
B

Bob Day

VS 2003, vb.net, SQL MSDE...

Using server explorer to create stored procedures, how do you put comments
into the stored procedure (after the name would be the logical place)?
Something like ' or REM don't work, and I cannot find anything in the SQL
books on line that indicates how. I am just looking to add some
documentation to the Stored Procedure to state their purpose, etc.

Thanks
Bob
 
Bob Day said:
VS 2003, vb.net, SQL MSDE...

Using server explorer to create stored procedures, how do you put comments
into the stored procedure (after the name would be the logical place)?
Something like ' or REM don't work, and I cannot find anything in the SQL
books on line that indicates how. I am just looking to add some
documentation to the Stored Procedure to state their purpose, etc.

create procedure ProcWithComment as
-- this is a comment
-- and this too
go

Eirik M
 
Back
Top