SqlServer快捷键查询表前100条数据

1.新建存储过程:

CREATE PROC [dbo].[sp_select](@sql VARCHAR(1000))    
AS    
BEGIN    
SET @sql='select top 100 * from ' + @sql;    
EXEC (@sql);    
END
GO

 

2.设置快捷键