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.
Click to expand...

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

Eirik M
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Use ADO.NET Entity Data Model utility for stored procedures or vie 1
Stored Procedure fast in SSMS but times out in ADO.NET app 5
Stored procedures 4
Creating Stored Procedure 5
Stored Procedures Query 7
Stored Procedure call failed in VB.NET 4
How to debug a stored procedure from ObjectContext.ExecuteFunction 1

Back
Top