Last active
October 23, 2017 18:56
-
-
Save sdoubleday/a791f4c1969be1ca796cda3db132d96f to your computer and use it in GitHub Desktop.
My SSMS Keyboard Query Shortcuts
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sp_executesql @stmt = N'SELECT '',['' + Table_name + ''].['' + Column_Name + '']'' AS QualifiedColumnName , * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE @input', @params = N'@input varchar(1000)', @input = | |
| SELECT * FROM | |
| sp_HelpText | |
| SELECT TOP 60 * FROM | |
| sp_BlitzFirst @expertmode = 1, @seconds = 5 | |
| sp_BlitzWho | |
| select 'remember two part names.'; EXEC sp_executesql N'select * FROM sys.dm_sql_referencing_entities(@targ,''Object'');select * FROM sys.dm_sql_referenced_entities(@targ,''Object'')', N'@targ NVARCHAR(1024)', @targ = |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment