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