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
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