CODEWITHSUNDEEP
sql-serverssmssql-server-2014
HeadOverFeet
HeadOverFeet

Reputation: 788

User shortcuts setting in SQL Server Management Studio 2014?

Do you know where in SSMS 2014 can I set up my own shortcuts? For example: in ORACLE SQL I set up that 

sf = select * from

By this I only wrote in execution window sf and it wrote select * from.

Where and how can I set it in SSMS 2014?

Thank you.

Upvotes: 3

Views: 2086

Answers (1)

Panagiotis Kanavos
Panagiotis Kanavos

Reputation: 131189

SQL Server doesn't have shortcuts. SSMS is a separate product, based on the Visual Studio shell.

SSMS is a separate free product now, which supports all SQL Server versions from 2008 upwards (including SQL Server for Linux). The latest update came out on December 5. Updates are released regularly every month.

It has the same shortcut functionality as Visual Studio. You can change and define new shortcuts from Tools > Options > Environment > Keyboard

You can specify snippets in the Code Snippets Manager, Tools > Code Snippets Manager whose shortcut is Ctrl+K, Ctrl+B. You can insert a snippet by hitting Ctrl+K, Ctrl+X

There are several tutorials that explain how to use Code Snippets, eg Add T-SQL Snippets from the docs, Getting started with Code Snippets feature of SQL Server 2012, the similar SQL snippets in SQL Server Management Studio

It is a good idea to install the latest SSMS version. Now that it's a separate product, earlier versions won't get the same updates as the current one

Upvotes: 2

Related Questions