CODEWITHSUNDEEP
sql-servereditorvisual-studio-2012
Peter
Peter

Reputation: 14518

Can I define #regions in the visual studio 2012 t-sql editor?

I would like to know if there is an extension that allows me to define regions inside the visual studio 2012 editor while editing user defined functions or plain t-sql queries.

I've tried the following but it doesn't seem to do much:

-- #region This is a region with t-sql code
   ...
-- #endregion

Upvotes: 6

Views: 3478

Answers (1)

SchmitzIT
SchmitzIT

Reputation: 9572

SQL Visualizer allows for code regions. Using that, you can start a region with --REGION and end it again with -- END REGION.

There's also the SSMS toolpack.

Natively, you could choose to wrap the specific blocks with BEGIN and END statements:

http://msdn.microsoft.com/en-us/library/cc281835.aspx

Upvotes: 4

Related Questions