Posted by promptsql on 10/21/43 11:31

I said expanding '*' was on the list of things to be implemented --
we've just released PromptSQL 1.2 Beta one, and this was one of the new
features.

You can now type
SELECT *[TAB] FROM Orders, Customers
and the * will be expanded to insert all the columns in Orders and
Customers, prefixed by appropriate aliases. The separator is
customizable.

Or you can type:
SELECT o.*[TAB] FROM Orders o, Customers and the o.* will be replaced
by a list of all Orders columns, prefixed by "o."

Regards,
Damian (PromptSQL developer)

http://www.promptsql.com

• Next in forum: Question about Views and sp_refreshviews
• Prev in forum: Re: row level security across multiple columns
• Thread view: Re: excluding fields in SELECT statement

[Reply to this message]