SSMS Formatter use with Microsoft SQL Server Management Studio 2016
Hi friend's, today we are going to understand
that how to apply Format for your query in SSMS(Microsoft SQL Server Management
Studio 2016).
You just need to go through some steps that
mentioned below.
- First start the SQL Server (SSMS 2016)
- On the top of the Menu --> Tools --> Options
Fig 1.0
After open the Options pop up on left side shown the menu.
3. Environment
--> Keyboard --> under the Show Commands containing.
Fig 2.0
4. SSMSBoost.Format
--> select Use new shortcut in: --> Text Editor --> Press shortcuts
keys: Ctrl + k, Ctrl + D --> Click On 'Assign' and then Click 'OK'.
5. All
set to format your Query. Now just write query and apply you Short Cut key.
Hope,
This will help you.Thank
You.
