Comments
Sort by recent activity
Hi,
Thanks for posting. I'm getting the columns at that point, although the CL doesn't pop up automatically, I have to press Ctrl + Shift to get it. Is that what's happening for you? If not, could you tell me what version of SQL Prompt and what editor you are using? And if possible the exact script?
Regards,
Tilman / comments
Hi,
Thanks for posting. I'm getting the columns at that point, although the CL doesn't pop up automatically, I have to press Ctrl + Shift to get it. Is that what's happening for you? If not, could ...
Hi Jamie,
except I have it configured to use the default CTRL-spacebar
Whoops, my bad, I meant Ctrl + Space. It's currently not possible to configure that command.
What I would like though is to automatically populate the column-list with every column in the table. Similar to how typing "SELECT *" followed by a tab creates the whole column-list.
Sorry, misunderstanding on my part. You can't expand the wildcard there, I'm afraid, but you can use the column picker, which is almost as quick. Please see the help on how to use the column picker (SQL Prompt>Help>Working with SQL Prompt>Using the Candidate List>Selecting candidates using the column picker).
Regards,
Tilman / comments
Hi Jamie,
except I have it configured to use the default CTRL-spacebar
Whoops, my bad, I meant Ctrl + Space. It's currently not possible to configure that command.
What I would like though is t...
Hi,
I've added your suggestion to our list.
Regards,
Tilman / comments
Hi,
I've added your suggestion to our list.
Regards,
Tilman
Hi,
I've amanded the original post, once more.
Thanks for posting,
Tilman / comments
Hi,
I've amanded the original post, once more.
Thanks for posting,
Tilman
Hi,
I've amended the original issue with your updates.
Regards,
Tilman / comments
Hi,
I've amended the original issue with your updates.
Regards,
Tilman
Hi Pete,
Thanks for reporting this. I've added an issue to our list.
Regards,
Tilman / comments
Hi Pete,
Thanks for reporting this. I've added an issue to our list.
Regards,
Tilman
Hi,
What elezar says is correct. The files should be quite self-explanatory.
SQL Refractor has the ability to save and load an option configuration
We are planning to do something like this in a future release.
Regards,
Tilman / comments
Hi,
What elezar says is correct. The files should be quite self-explanatory.
SQL Refractor has the ability to save and load an option configuration
We are planning to do something like this in a ...
What he said [image]
Regards,
Tilman / comments
What he said
Regards,
Tilman
Hi,
You can actually use aliases in DELETE (and UPDATE) statements, but you have to specify them in the FROM clause.
E.g.
DELETE FROM t
FROM mytable t
WHERE t.
This would do what you want it to. Obviously the FROM clause is a bit superfluous when you specify only 1 table.
Regards,
Tilman / comments
Hi,
You can actually use aliases in DELETE (and UPDATE) statements, but you have to specify them in the FROM clause.
E.g.
DELETE FROM t
FROM mytable t
WHERE t.
This would do what you want it to. Ob...
Hi,
Please contact sales (sales@red-gate.com) regarding any licensing issues.
Regards,
Tilman / comments
Hi,
Please contact sales (sales@red-gate.com) regarding any licensing issues.
Regards,
Tilman