Getting started with Microsoft SQL Server OVER Clause PIVOT / UNPIVOT Database Snapshots Retrieve information about the database The STUFF Function FOR XML PATH Cursors Join Common Table Expressions Move and copy data around tables Dates Limit Result Set Retrieve Information about your Instance With Ties Option Variables JSON in Sql Server Window functions Partitioning Stored Procedures GROUP BY Generating a range of dates COALESCE Split String function in Sql Server INSERT INTO CREATE VIEW String Functions Resource Governor ORDER BY WHILE loop System database - TempDb Migration Primary Keys MERGE Full-Text Indexing FOR JSON SELECT statement DBMAIL Index Queries with JSON data Storing JSON in SQL tables OPENJSON Ranking Functions Trigger Converting data types NULLs Transaction isolation levels Advanced options IF...ELSE TRY/CATCH Data Types User Defined Table Types Table Valued Parameters In-Memory OLTP (Hekaton)Temporal Tables Insert Sequences SCOPE_IDENTITY()Views Use of TEMP Table Scheduled Task or Job Isolation levels and locking Sorting/ordering rows Privileges or Permissions Foreign Keys SQLCMD File Group cross apply Basic DDL Operations in MS SQL Server Computed Columns UNION Subqueries Last Inserted Identity CLUSTERED COLUMNSTORE Parsename Installing SQL Server on Windows Aggregate Functions Querying results by page Schemas Backup and Restore Database Transaction handling Natively compiled modules (Hekaton)Database permissions Spatial Data Dynamic SQL Pagination Query Hints Modify JSON text Row-level security Dynamic data masking Export data in txt file by using SQLCMD Encryption Managing Azure SQL Database Common Language Runtime Integration Delimiting special characters and reserved words CASE Statement DBCC BULK Import Query Store Service broker Analyzing a Query Microsoft SQL Server Management Studio Shortcut Keys Permissions and Security PHANTOM read Filestream Drop Keyword String Aggregate functions in SQL Server SQL Server Evolution through different versions (2000 - 2016)SQL Server Management Studio (SSMS)Logical Functions Dynamic SQL Pivot Alias Names in Sql Server bcp (bulk copy program) Utility

Microsoft SQL Server Management Studio Shortcut Keys

Shortcut Examples

Open a new Query Window with current connection (Ctrl + N)
Toggle between opened tabs (Ctrl + Tab)
Show/Hide Results pane (Ctrl + R)
Execute highlighted query (Ctrl + E)
Make selected text uppercase or lowercase (Ctrl + Shift + U, Ctrl + Shift + L)
Intellisense list member and complete word (Ctrl + Space, Tab)
Go to line (Ctrl + G)
close a tab in SQL Server Managament Studio (Ctrl + F4)

Menu Activation Keyboard Shortcuts

Move to the SQL Server Management Studio menu bar (ALT)
Activate the menu for a tool component (ALT+ HYPHEN)
Display the context menu (SHIFT+F)
Display the New File dialog box to create a file (CTRL+N)
Display the Open Project dialog box to open an existing project (CTRL+SHIFT+0)
Display the Add New Item dialog box to add a new file to the current project (CTRL+SHIFT+A)
Display the Add Existing Item dialog box to add an existing file to the current project (CTRL+SHIFT+A)
Display the Query Designer (CTRL+SHIFT+Q)
Close a menu or dialog box, canceling the action (ESC)

Custom keyboard shortcuts

Go to Tools -> Options. Go to Environment -> Keyboard -> Query Shortcuts

On the right side you can see some shortcuts which are by default in SSMS. Now if you need to add a new one, just click on any column under Stored Procedure column.

Click OK. Now please go to a query window and select the stored procedure then press CTRL+3, it will show the stored procedure result.

Now if you need to select all the records from a table when you select the table and press CTRL+5(You can select any key). You can make the shortcut as follows.

Now go ahead and select the table name from the query window and press CTRL+4(The key we selected), it will give you the result.

Contributors

Topic Id: 7749

Example Ids: 25409,25501,25815

This site is not affiliated with any of the contributors.