Creating Query Shortcuts in SQL Server Management Studio

You can create shortcuts for commonly used queries in SQL Management Studio. Some of the shortcuts are predefined, like  "Alt + F1" will execute "sp_help" and "Ctrl + 1" will execute "sp_who". You can create new shortcuts for your own queries.

To create a new shortcut,

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

For example, you can create a shortcut for:

Syntax

"Ctrl + 3 " : SELECT * FROM  (single space after from keyword)

    

Find Data Base Table With Primary Key

SELECT  Tab.TABLE_NAME AS TABLE_NAME,
  COLUMN_NAME AS PRIMARY_KEY_COLUMN
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS TC
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS Tab
  ON TC.CONSTRAINT_TYPE = 'PRIMARY KEY'
  AND TC.CONSTRAINT_NAME = Tab.CONSTRAINT_NAME
  AND Tab.TABLE_NAME = 'TABLE'
ORDER BY Tab.TABLE_NAME,
Tab.ORDINAL_POSITION;

Get Autoclose and Autoshrink Values for the Databases in Sql Server

select databasepropertyex('yourdb','isautoshrink')


You can change it with the ALTER DATABASE statement


ALTER DATABASE yourdb

SET AUTO_SHRINK OFF | ON

How to Find In Valid Object Name SQL Server

SELECT   STORED_PROCEDURE = QUOTENAME(SCHEMA_NAME(O.[SCHEMA_ID])) + '.' + QUOTENAME(O.NAME),
  OBJ_TYPE = O.TYPE_DESC,

  D.REFERENCED_DATABASE_NAME,s

  D.REFERENCED_SCHEMA_NAME,
  D.REFERENCED_ENTITY_NAME
FROM SYS.SQL_EXPRESSION_DEPENDENCIES D
JOIN SYS.OBJECTS O
  ON D.REFERENCING_ID = O.[OBJECT_ID]
WHERE D.IS_AMBIGUOUS = 0
AND D.REFERENCED_ID IS NULL
AND D.REFERENCED_SERVER_NAME IS NULL -- IGNORE OBJECTS FROM LINKED SERVER
AND CASE D.REFERENCED_CLASS -- IF DOESN’T EXIST
  WHEN 1 -- OBJECT
  THEN OBJECT_ID(
    ISNULL(QUOTENAME(D.REFERENCED_DATABASE_NAME), DB_NAME()) + '.' +
    ISNULL(QUOTENAME(D.REFERENCED_SCHEMA_NAME), SCHEMA_NAME()) + '.' +
    QUOTENAME(D.REFERENCED_ENTITY_NAME))
  WHEN 6 -- OR USER DATATYPE
  THEN TYPE_ID(
    ISNULL(D.REFERENCED_SCHEMA_NAME, SCHEMA_NAME()) + '.' + D.REFERENCED_ENTITY_NAME)
  WHEN 10 -- OR XML SCHEMA
  THEN (SELECT
      1
    FROM SYS.XML_SCHEMA_COLLECTIONS X
    WHERE X.NAME = D.REFERENCED_ENTITY_NAME
    AND X.[SCHEMA_ID] = ISNULL(SCHEMA_ID(D.REFERENCED_SCHEMA_NAME), SCHEMA_ID()))
END IS NULL

Comma Separated Columns & Table Name To All Data Base

SELECT OBJECT_SCHEMA_NAME(T.[object_id], DB_ID()) AS [Schema], T.[name] AS [table_name], AC.[name] AS [column_name], TY.[name] AS system_data_type, AC.[max_length], AC.[precision], AC.[scale], AC.[is_nullable], AC.[is_ansi_padded], AC.* FROM sys.[tables] AS T LEFT JOIN sys.[all_columns] AC ON T.[object_id] = AC.[object_id] LEFT JOIN sys.[types] TY ON AC.[system_type_id] = TY.[system_type_id] AND AC.[user_type_id] = TY.[user_type_id] WHERE 1 = 1 AND AC.[max_length] = -1 ORDER BY T.[name], AC.[column_id]