"Orchid XP v7" <voi### [at] devnull> wrote in message
news:47d17435$1@news.povray.org...


> The last three completely stumped me. One wanted me to take some data
> from one table and insert it into another one. I know how that's done, I
> just don't remember the command syntax off the top of my head.

INSERT INTO SomeTable (<Column names>)
SELECT <Columns> FROM SomeOtherTable
WHERE <Any relevant conditions>

> Another
> wanted me to use "cursors" - something I've never ever done before. I
> don't even know what one *is*.

Slow and inefficient.

> PS. Apparently "I see plenty of people who claim to know SQL who do
> worse than you did. You're really underselling yourself, Andrew. I
> wasn't even expecting you to ATTEMPT those last few..."

Yup. I see that too. People claiming to have 4 years of SQL experience and
can't write a  basic select statement

Post a reply to this message