T-SQL "Code Wrapping" in SSMS 2012

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!
LVL 1
ttist25Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Pawan KumarDatabase ExpertCommented:
In SQL Server we do not have anything like that.

#Region
....
#EndRegion

we have this in .NET

If we long code SQL automatically shows - ( hyphen )

click on that SQL collapse the long code.
0
Pawan KumarDatabase ExpertCommented:
Example of above comment. This is how you toggle the outlines.

EE.jpg
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ttist25Author Commented:
Thank you Pawan!

That isn't exactly what I had envisioned but it definitely gets the job done.  

Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.