Settings and activity
5 results found
-
23 votesSduval supported this idea ·
-
63 votes
An error occurred while saving the comment -
28 votes
An error occurred while saving the comment Sduval commentedCheck out SSMS Boost, I use it in tandem with SQL complete and the two apps together have really made stock SSMS so much better
-
133 votesSduval supported this idea ·
-
3 votesAdminDevart (_, Devart) responded
Could you please provide us an example of this?
You can send the reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
An error occurred while saving the comment Sduval commentedI have query 1 that I write to pull from one table:
SELECT DNA.a
,DNA.b
,DNA.c
,DNA.d
,DNA.e
,DNA.f
FROM dbo.DNA WITH (NOLOCK)Now I want to create query two (or just change query 1 to look at a different table with identical structure:
SELECT DNA.a
,DNA.b
,DNA.c
,DNA.d
,DNA.e
,DNA.f
FROM dbo.DNA_HISTORY WITH (NOLOCK)I’d love the ability to do this with query two:
1. Either have the auto alias be able to replicate the full table name:
a. FROM dbo.DNA DNA WITH (NOLOCK)
i. So I can then press F2 and change the name to history
a. FROM dbo.DNA DNA_HISTORY WITH (NOLOCK)
c. Option 2 would be to just allow for the rename on the table name without an alias.Once the rename is complete I can remove the first DNA (from the second query) and leave just dbo.DNA_History now that all the column names have an updated table reference.
Sduval shared this idea ·
Check out SSMS Boost, I use it in tandem with SQL complete and the two apps together have really made SSMS so much better