select table with keyboard shortcut

1. 아래 프로시저를 생성

  
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Jaeyong Park
-- Create date: 2016-11-15
-- Description:	테이블 Select
-- exec spTableSelect 'bcc100'
-- =============================================
ALTER PROCEDURE [dbo].[spTableSelect] 
@TABLE_NAME VARCHAR(100),
@COUNT VARCHAR(10) = NULL
AS
BEGIN
	IF EXISTS (SELECT NULL FROM sys.objects WHERE TYPE IN ('U','V') AND name=@TABLE_NAME)
	BEGIN
		IF @COUNT IS NULL
			SET @COUNT=1000
			EXEC('select top ' + @COUNT + ' * from ' + @TABLE_NAME + '(nolock)')
		END
		ELSE
			print 'Table not found.'
	END
GO

2. 옵션 - 환경 - 키보드 - 쿼리 바로가기 할당