Activity overview
Latest activity by buckley
Schema and Db with the same name: no Db suggestions
Hi,
i don't know if its by design but if there is a schema in the current database that has the same name as a database then suggestions for the other database will not show up. Took me a while to ...
No problem here with 7.1.0.306
(Replaced the variables by constants though)
SELECT
1 ,
c.CategoryNameLTID ,
ROW_NUMBER() OVER (ORDER BY ID) AS Row ,
2 ,
3
FROM
BestPracticeLibrary.Categories AS c; / comments
No problem here with 7.1.0.306
(Replaced the variables by constants though)
SELECT
1 ,
c.CategoryNameLTID ,
ROW_NUMBER() OVER (ORDER BY ID) AS Row ,
2 ,
3
FROM
BestPracticeLibrary.Categories AS c;
Thanks Aaron. Detached and attached some votes to the request. / comments
Thanks Aaron. Detached and attached some votes to the request.
Ha! I guess I want to interfere too much [image]
"
You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.
"
This was the item I was trying to create on the UserVoice forum Subject: Switch to a server from code Body:
I propose a feature where I can type a server and switch to it.
Either by executing the line I just typed or that Prompt, after observing my keystrokes, does automatically
Example,
===
Select x ...
--switch ServerX
Select x ...
===
If I execute the second line the connection would be to ServerX
Note 1
In SqlCmd mode we have the :CONNECT directive but its not permanent. SSMS switches to the new server and immediately switches to the old.
Maybe this directive can be used if there is a way to not mess with the original semantics of putting ssms in sqlcmd mode
Originating forum thread viewtopic.php?f=169&t=79455 / comments
Ha! I guess I want to interfere too much
"
You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.
"
This was the item I was trying...
I tried assigning it a shortcut but it does not work as the sources on the net are tied to particular ssms version it seems.
I'll give it another go
It would be a nice feature though not just to quickly switch servers but to have a script that can command multiple servers, fe:
===
Select ...
--switch ServerX
Select ...
--switch ServerY
Select ...
--switch ServerZ
===
Did you notice the :CONNECT directive once executed switches back to the original server? So recuperating this directive is not a way to switch a server unless Prompt changes the semantics if it is executed on its own for example. / comments
I tried assigning it a shortcut but it does not work as the sources on the net are tied to particular ssms version it seems.
I'll give it another go
It would be a nice feature though not just to qu...
Hello Aaron! We are with a group of 3 developers and our counting on Prompt daily. Still no comparison!
The main reason for asking this feature is to quickly switch between servers from the keyboard
For example, embedding prompt commands in comment like the following
--Connect ServerX
Once "executed" (in quotes as it is a comment but prompt understands) it will switch to that server
That's it.
Building further on this the feature can be expand to support intellisense after a "prompt command".
So that it statically knows by parsing the text that the commands after the prompt command are for another server.
This expansion is a nice to have. I was mainly looking for a way to switch between servers as no other extension that I know offers it and I still have to go through the "change connection" button/menu in ssms.
Makes sense? I will formulate it as a uservoice item as well but would like to use this forum to align our understanding of what the feature is and why it can be useful.
Kr, Tom / comments
Hello Aaron! We are with a group of 3 developers and our counting on Prompt daily. Still no comparison!
The main reason for asking this feature is to quickly switch between servers from the keyboar...
Connect to a server from (pseudo?) tsql
Hello Support,
When I learned about sqlcmd mode in ssms I got my hopes up that I could switch in my tsql from server. Something that I do many times a minute :
:CONNECT ServerX
It turns out that ss...
Great Stuff. I could do suggestions to prompt every day and test them out the next [image] But I have to do some work as well.
Thanks a lot Aaron. This makes guids a bit less awkward to work with. / comments
Great Stuff. I could do suggestions to prompt every day and test them out the next But I have to do some work as well.
Thanks a lot Aaron. This makes guids a bit less awkward to work with.
Aaron +1 +1 / comments
Aaron +1 +1
Support for guid's in snippets
Hi Aaron,
Is there a placeholder for generating a guid? This would be super helpful
Currently we have TIME,MACHINE etc
Can you add a GUID or UNIQUEIDENTIFIER ?
Thanks, Tom