Settings and activity
7 results found
-
1 vote
Adam
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
commented
ssms tools has had it a long time.
This is a very useful feature. -
1 vote
AdminDevart
(_, Devart)
responded
You might be referring to the Tabs Color feature that can be setup in the ‘Tabs Color’ section of the ‘Options’ window (select ‘SQL Complete → Options…’ from the main menu).
Adam
shared this idea
·
-
3 votesAdam
shared this idea
·
-
4 votes
AdminPMs
(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