Skip to content

Instantly share code, notes, and snippets.

@sdoubleday
Last active October 23, 2017 18:56
Show Gist options
  • Select an option

  • Save sdoubleday/a791f4c1969be1ca796cda3db132d96f to your computer and use it in GitHub Desktop.

Select an option

Save sdoubleday/a791f4c1969be1ca796cda3db132d96f to your computer and use it in GitHub Desktop.
My SSMS Keyboard Query Shortcuts
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