New Features in SSMS Denali

1. Surround With Feature This feature allows us to select a set of T-SQL statements and enclose them into Transactional, Conditional, & Looping etc. constructs like Begin-End, If-Else, & While etc.   Steps: i) Open SSMS and open Query Editor ii) Enter the query and select the query iii)  On selecting Surround With… from context…

3

Sequences in SQL Server

Customers have been asking for sequences for a very long time and now finally it is included with SQL Server Denali CTP 1. You don’t have to do workaround of sharing identity table across all tables now. Creating a Sequence: CREATE SEQUENCE counter AS INT MINVALUE 1 NO MAXVALUE START WITH 1; GO Get Next…

1