#region functionality in SSMS 2008

sql sql-server visual-studio region
Sesame picture Sesame · Jul 27, 2010 · Viewed 12.2k times · Source

Using Sql Server 2008, is there any functionality similar to #region in Visual Studio?

I'm aware that nodes appear to allow collapsing of SQL segments, but as far as I know, this is based on the syntax of the SQL statement.

While that is close to what I'm after, I'm wondering if there is a way to define a section of code, regardless of syntax, similar to #region/#endregion.

Any thoughts?

Answer

sql xdetails picture sql xdetails · Jan 24, 2014

Yes, there is native support in SSMS 2008 on, without any addins. The regions are defined by:

  1. From first GO command to next GO command.
  2. Statements between BEGIN – END, BEGIN TRY – END TRY, BEGIN CATCH – END CATCH
  3. Multiline statements

See examples here: http://blog.sqlauthority.com/2009/06/28/sql-server-2008-management-studio-new-features-2/

Related questions

Warning SQL71502 - Procedure <name> has an unresolved reference to object <name>

I'm getting the following warning in my Visual Studio 2013 project: SQL71502 - Procedure has an unresolved reference to object

Read More
SQL Server project executing multiple script post deploy

I have a SQL Server 2008 DB Project, and want to execute multiple scripts, in order, on post deploy. I've added a PostDeploy.Sql script to a scripts folder, and marked that as PostDeploy, and that works fine. I'm aware that …

Read More
Do I need a database reference for a linked server in a SQL Server database project?

In my database project, I have added a reference to a linked server. When I use this linked server in a view and try to build my database project, SSDT reports errors because it cannot understand references to any of …

Read More