Preserve SQL with CodeSmith

Question

How would I create a procedure with a PRESERVE region like this:

CREATE PROCEDURE RunSQL
AS

--region Custom processing
--endregion

SELECT * FROM SomeTable

GO

Answer 1

For T-SQL your code would need to look like this:

RegionNameRegex should be set to ^[ \t][ \s]"?(?i:Custom)"?; Language should be set to "T-SQL";

Your regions should look like this:

--region Custom Parameters

--endregion

I have created a sample template located here.

Thanks -Blake Niemyjski