EXISTS (SELECT ... FROM) optional?

Interesting... Consider proposing at http://lab.msdn.microsoft.com/productfeedback
/
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Axel Dahmen" <NO_SPAM@.NoOneKnows.invalid> wrote in message
news:uKzl7fWAGHA.4004@.TK2MSFTNGP15.phx.gbl...
> Hi,
> in SQL there is a term that's bothering me:
> EXISTS (SELECT ... FROM
> I guess generations of SQL programmers put some brains into thinking of so
me
> expression to put after the "SELECT" term. I usually use a NULL, like
> EXISTS (SELECT NULL FROM
> I tend to believe this term is as redundant as DELETE * FROM. Wouldn't it
be
> good to have this part optional, like with the DELETE statement? Like:
> EXISTS ([SELECT <column>[,<column>] FROM ] <tablename> ...)
> so it would be a valid term to write:
> EXISTS (MyTable WHERE MyIdColumn = 1234)
> RFC,
> Axel Dahmen
>Thanks, David, Tibor and Uri, for your valuable contributions. I'm glad if
you like the idea and that it is not as foolish as I was anxious to expect.
If you believe the suggestion to be helpful than I'll gladly suggest it
there.
Regards,
Axel Dahmen
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u4jc7rWAGHA.3584@.TK2MSFTNGP14.phx.gbl...
> Interesting... Consider proposing at
http://lab.msdn.microsoft.com/productfeedback/
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Axel Dahmen" <NO_SPAM@.NoOneKnows.invalid> wrote in message
> news:uKzl7fWAGHA.4004@.TK2MSFTNGP15.phx.gbl...
some
it be
>