Hey there -
I'm writing a lot of one off scripts in SSMS during analysis of new datasets. I'm trying to figure out a way to code wrap regions in SSMS. I haven't found anything in searches other than plugin/addon stuff which I'd like to avoid.
Does anyone have any tricks that would allow me to create a collapsable "region" anywhere in my code in SSMS.
Something like:
SELECT
#RegionFields
this,
that,
the,
other
#/EndRegionFields
FROM
MyTable
WHERE
#RegionCriteria
this=that and
deez=doze and
so=on and
so=on
#EndRegionCriteria
So that anything between the #Regions would be collapsable.
TIA!
Our community of experts have been thoroughly vetted for their expertise and industry experience.
This award recognizes a member of Experts Exchange who has made outstanding contributions to the community within their first year as an expert. The Rookie of the Year is awarded to a new expert who has the highest number of quality contributions.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.