Comments
Sort by recent activity
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...
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
Good to know Aaron. I can't immediately upgrade but this is a little bug anyways. Loving prompt ! / comments
Good to know Aaron. I can't immediately upgrade but this is a little bug anyways. Loving prompt !
FYI
I was thinking that formatting had a prob with sql keywords like Exists
But I'm guessing that its if you use brackets in the order by
ORDER BY [Last Time Job Ran On] DESC
=>
ORDER BY [] DESC
This is just FYI as its fixed in a later build as you cannot reproduce / comments
FYI
I was thinking that formatting had a prob with sql keywords like Exists
But I'm guessing that its if you use brackets in the order by
ORDER BY [Last Time Job Ran On] DESC
=>
ORDER BY [] DESC
Th...
Hey Aaron, it's 6.5.0.183 / comments
Hey Aaron, it's 6.5.0.183