Home How can I avoid these comments getting rendered in a SQL Server stored procedure?
Reply: 0

How can I avoid these comments getting rendered in a SQL Server stored procedure?

user856
1#
user856 Published in May 25, 2018, 2:20 pm

I'm creating a large SQL file with all of my ddl scripts for a database deployment. I'm using code folding in Notepad++ to be able to provide some structure and separation to the scripts. I've configured this in Notepad++:

--#region => GetAllUsers

CREATE SPROC GetAllUsers
AS
BEGIN
END

--#endregion
--#region => GetAllGroups

CREATE SPROC GetAllGroups
AS
BEGIN
END

--#endregion

This works as expected but the problem is that when I choose to modify GetAllUsers in SSMS, the output looks like this:

CREATE SPROC GetAllUsers
AS
BEGIN
END

--#endregion
--#region => GetAllGroups

Is there a way I can maintain the code folding structure but avoid the additional code-folding comments from getting added at the end of the stored procedure definition?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.323362 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO