What are the challenges you face when working across database platforms? Take the survey
Options

Comments at start of procedure ignored

davegrdavegr Posts: 15
edited April 25, 2011 12:12PM in SQL Prompt Previous Versions
Hi,

If I create a SP as follows and then do an ALTER PROCEDURE {tab} SQL Prompt fills in the procedure code but leaves out the first comment. If the comments are moved after the CREATE PROCEDURE line then they are included.

/* comments here are ignored by Inserted Code for ALTER statements */
CREATE PROCEDURE test
/* comments here work fine */
AS
SELECT 'test' AS Col1
GO

The comments are in the procedure as they do show correctly if I use the SSMS script generation context menu options.

Can this be changed so comments at the start of a procedure are included?

Thanks

Dave

Comments

Sign In or Register to comment.