How to update a table based on a query returning any rows

Question

How to update a table based on a query returning any rows

-- -- 957

Hi

We have a select query on a table. Based on if the query returns any rows, how can we update a column in a second table?

Thanks

Regards

Accepted answer

1 additional answer

Your answer

Answer 1

Viorel 122.6K

For example, you can do something like this:

if exists( select * from Table1 ) -- if the first query returns any row
   update Table2 -- update a column in the second table
   set SomeColumn = 'some value'

It depends on different aspects of your problem.

Answer 2

Anonymous

Hi @-- --

If what you need is that a change to Table 1 will update Table 2, you can use triggers to solve it. But here, all you want is to update Table 2 as soon as the contents of the table are retrieved.

You can try the method provided by Viorel, you can add the conditions you want in the query in parentheses after exists.

Best regards,

Percy Tang

Share via

How to update a table based on a query returning any rows

1 additional answer

Your answer