sql server region

Question

can i create regions in sql server editor  like  region and  endregion in C

User · Answer

BEGIN   END works  you just have to add a commented section   The easiest way to do this is to add a section name   Another route is to add a comment block   See below   BEGIN  -- Section Name     Comment block some stuff  --end comment should be on next line      --Very long query SELECT   FROM FOO SELECT   FROM BAR END

User · Answer

It is just a matter of using text indentation in the query editor   Expanded View     Collapsed View

User · Answer

No   region does not exist in the T-SQL language   You can get code-folding using begin-end blocks    -- my region begin     -- code goes here end   I m not sure I d recommend using them for this unless the code cannot be acceptably refactored by other means though

User · Answer

I ve used a technique similar to McVitie s  and only in stored procedures or scripts that are pretty long   I will break down certain functional portions like this   BEGIN     delete queries      DELETE FROM blah blah  END     delete queries      BEGIN     update queries      UPDATE sometable SET something   1  END     update queries       This method shows up fairly nice in management studio and is really helpful in reviewing code   The collapsed piece looks sort of like   BEGIN     delete queries             delete queries       I actually prefer it this way because I know that my BEGIN matches with the END this way

User · Answer

Another option is   if your purpose is analyse your query  Notepad  has useful automatic wrapper for Sql

User · Answer

Not out of the box in Sql Server Management Studio  but it is a feature of the very good SSMS Tools Pack

User · Answer

I am developer of SSMSBoost add-in for SSMS   We have recently added support for this syntax into our SSMSBoost add-in   -- region  Optional Name  -- endregion   It has also an option to automatically  recognize  regions when opening scripts

User · Answer

Not really  Sorry  But     Adding begin and end   with a comment on the begin creates regions which would look like this   bit of hack though     Otherwise you can only expand and collapse you just can t dictate what should be expanded and collapsed  Not without a third-party tool such as SSMS Tools Pack

[sql-server] sql server #region

Examples related to sql-server

Examples related to region