how to update 3 linked tables in sql

Question

1.00/5 (1 vote)

See more:

SQL

I have 3 tables T1,T2,T3
T1(t1id=pk,field1...)
T2(t2id=pk,field2,t1id=fk)
T3(t3id=pk,field3,t2id=fk)

Posted 30-Jan-16 7:18am

Sofari Sofari

Add a Solution

Comments

Kornfeld Eliyahu Peter 30-Jan-16 13:23pm

And the question is?
You must be much more specific/detailed so we can help you...

John C Rayan 30-Jan-16 14:53pm

what are you updating? Give some info.

Dave Kreskowiak 30-Jan-16 16:16pm

Without more information, the short answer is "update one at a time".

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Accepted Answer · 2016-01-31T02:53:00

With so little information it is almost impossible to give you proper advice. However the following information may prove useful to you...

Learn about SQL Transactions. Some links -
A Beginner's Tutorial for Understanding Transactions and TransactionScope in ADO.NET[^]
SQL Transactions[^]

and TRY-CATCH - see Using Try... Catch..., Finally![^]

e.g.

BEGIN TRY
    BEGIN TRANSACTION
        -- update table T1
        -- update table T2
        -- update table T3
    COMMIT TRANSACTION
END TRY
BEGIN CATCH
    ROLLBACK TRANSACTION
END CATCH

Either all three tables will be successfully updated or none of them will.

The fact that you are having to update 3 linked tables may mean that you haven't normalised your database sufficiently - have a look at Basics of Normalization[^]