Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Productivity Keyboard Shortcuts

By Emil Bialobrzeski,

1. Go to Tools >> Options

2. Environment // Keyboard

3.

For CTRL+3 enter DECLARE @DB NVARCHAR(500) SET @DB = DB_NAME() EXEC Utils.dbo.Utils 3, @DB,

For CTRL+4 enter DECLARE @DB NVARCHAR(500) SET @DB = DB_NAME() EXEC Utils.dbo.Utils 4, @DB,

For CTRL+5 enter DECLARE @DB NVARCHAR(500) SET @DB = DB_NAME() EXEC Utils.dbo.Utils 5, @DB,

For CTRL+6 enter DECLARE @DB NVARCHAR(500) SET @DB = DB_NAME() EXEC Utils.dbo.Utils 6, @DB,

For CTRL+7 enter DECLARE @DB NVARCHAR(500) SET @DB = DB_NAME() EXEC Utils.dbo.Utils 7, @DB,

For CTRL+8 enter DECLARE @DB NVARCHAR(500) SET @DB = DB_NAME() EXEC Utils.dbo.Utils 8, @DB,

For CTRL+9 enter DECLARE @DB NVARCHAR(500) SET @DB = DB_NAME() EXEC Utils.dbo.Utils 9, @DB,

For CTRL+0 enter DECLARE @DB NVARCHAR(500) SET @DB = DB_NAME() EXEC Utils.dbo.Utils 0, @DB,

4. Run script

5. Restart SSMS

Description:

CTRL+3: selects TOP 1000 rows from a selected table or view (highlite table name in text editor and hit shortcut)

CTRL+4: is Showing details of a table or if it's a SP,FN,TR,VW Scripts the object (very good to quickly check table structure or script a procedure into text editor, just highlite and hit shortcut)

CTRL+5: searches for a database object with selected name in it (# char works like % wildcard, lets say you are looking for object starting with 'ab' and ending with 'xyz', type [ab#xyz] select and hit shortcut)

CTRL+6: NOT IMPLEMENTED

CTRL+7: NOT IMPLEMENTED

CTRL+8: searches for table or view with selected column name in it

CTRL+9: listing columns from selected table or view

CTRL+0: looks for an object that contains selected phrase in the objects script (# char works like % wildcard, lets say you are looking for object containing 'ab...xyz' in the script, type [ab#xyz] select and hit shortcut)

These were made based on te default [dbo] schema so feel free to adjust for your own needs. Just wanted to share something i can't work without anymore.

 

PS. Any ideas for 6 and 7?

Total article views: 2126 | Views in the last 30 days: 44
 
Related Articles
FORUM

Different Behaviour of VARCHAR and NVARCHAR

Variables declared with VARCHAR and NVARCHAR were behaviouring differently.

FORUM

nvarchar -int

nvarchar -int

FORUM

nvarchar max problem

nvarchar max not fulfilling requirements

FORUM

Dynamic SQL Requirements

Does it have to be declared as nvarchar

FORUM

FK selection (an nvarchar(30) column or four int columns)

FK selection (an nvarchar(30) column or four int columns)

Tags
management studio (ssms)    
productivity    
shortcuts    
tool    
tools    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones