Updating 2 tables in sql christian teen advice on dating

Rated 3.90/5 based on 698 customer reviews

Every now and then you will get someone asking how to update two tables with one statement in SQL Server. the person then walks away muttering something about how My SQL allows it.

So I decided to try to see if I could update two tables with one statement.

I have a function that updates three tables, but I use three queries to perform this.

I wish to use a more convenient approach for good practice.

Since you can't list more than one table in the Oracle UPDATE statement, you can use the Oracle EXISTS clause.

Hello, I'm very new to Oracle Application Express and PL SQL.

When you look at this it looks very simple but when we try to think the solution, I have seen developers coming up with many different solutions for example sometime they write cursor, table variables, local variables etc.

This is one of the most interesting questions I keep on getting on this email and I find that not everyone knows about it. Our requirement is that we have Table2 which has two rows where Col1 is 21 and 31.I"m working on an input form to track meter information.Let's just say I have a header and a detail record.Let us clean up the clause by dropping the tables which we have created.Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant.

Leave a Reply