Update with Select Top

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tomer - 31 Mar 2004 15:06 GMT

I need to update the top first row of a table with a sql query,
I'v connected my ppc to a sql server 2000, and from the ppc i need to run
the query.
I know the query should look something like this:

update set code='xxx' (select top 1 * from tablename)

Any ideas?

Tomer.

Reply to this Message

William Ryan eMVP - 31 Mar 2004 16:53 GMT

Assume that you have a PK Column called Primary (Primary is a key word but
replace it with whatever your PK Column name is)

You could use UPDATE myTable SET code = 'xxx' where Primary = (SELECT TOP
1(Primary) From myTable)

> I need to update the top first row of a table with a sql query,
> I'v connected my ppc to a sql server 2000, and from the ppc i need to run
[quoted text clipped - 6 lines]
>
> Tomer.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...