SQL Server Jumping between braces not working in SSMS

ni65a41a  于 2023-03-11  发布在  其他
关注(0)|答案(1)|浏览(132)

I am trying to jump to the closing brace for any open brace in a valid SQL which has subqueries, using ctrl+]. It's not doing anything. The key combo seems to be mapped correctly. Using SSMS 17.3.

Any adeas?

zwghvu4y

zwghvu4y1#

are you sure you don't need to hold down the shift key? from SSMS docs

Text Selection Keyboard Shortcuts
Action                 SQL Server 2017                SQL Server 2008 R2
Move the cursor to the next brace, extending the selection  
                       CTRL+SHIFT+]                   No equivalent

and

Microsoft IntelliSense Keyboard Shortcuts
Action                      SQL Server 2017 SQL Server 2008 R2
Jump between syntax pairs   CTRL+]          CTRL+]

take a look under tools/options/text editor/all languages/general/settings (lower) section/Automatic Brace completion . Mine was filled in solid instead of checked. May not affect what you want, but may have some conflict dependent on the setting. Also, under the Transact-SQL language, the automatic brace completion option is disabled. Not sure if the settings are related.

相关问题