Settings and activity
6 results found
-
1 voteAdam shared this idea ·
-
2 votesAdam shared this idea ·
-
11 votes
An error occurred while saving the comment -
4 votesAdam supported this idea ·
An error occurred while saving the comment Adam commentedssms tools has had it a long time.
This is a very useful feature. -
3 votesAdam shared this idea ·
-
4 votesAdminPMs (Admin, Devart) responded
The whole script should be valid. This is by design.
Adam shared this idea ·
You can make yourself a master-based routine.
USE [master]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create PROC [dbo].[sp_Table1000]
@object sysname,
@horizontal tinyint = 1
AS
SET NOCOUNT ON
declare @polecenie varchar(500), @proces varchar(50)
select @polecenie = 'select top 50 * from '+DB_NAME()+'.dbo.' +@object
execute(@polecenie)
then you go to Tools> Options> Environment> Keyboard> Query Shortcust and add the procedure name to the shortcut
now selecting the table name in the code and pressing the shortcut will show you 1000 records