Sql Help

[goli soda]

Friends naku oka SQL problem vachindi..can you help me with that?

nenu oka data fix script rasthuna...dantlo 2 tables ki dependant foreign key relation undhi. Chlid table lo update chedam ani try chetshunte parent table ki dependent constraint error vasthundhi....sare munde parent table lo update chedam ani try chesthe chhild table same error. so a 2 tables ki inter dependency undhi... ante yee table lo modify chedam ani aa table lo check chesthundhi.. aa table lo chedam ante yee table lo check chesthundi.... constraint ni drop cheya kunda update chese option edana undha?

[goli soda]

enti evaru help cheyara?? oleyy ganna raava ekkada sachav???

[Bondu_Babu]

drop cheyyakunda ante naku idea ledhu ba general itu vanti case lo first drop chesi table ni update chesi foreign key ni active chestharu

[goli soda]

[quote name='Bondu_Babu' timestamp='1320156249' post='3053262']
drop cheyyakunda ante naku idea ledhu ba general itu vanti case lo first drop chesi table ni update chesi foreign key ni active chestharu
[/quote]

adokka option ye antavaa...

[Bondu_Babu]

[quote name='goli soda' timestamp='1320156470' post='3053278']

adokka option ye antavaa...
[/quote]

nenu expert ni kadhu ba naku telisindhi cheppa ante chudham inka evaaraina emaina cheptharu emo,gali bava ki pm pettu........

[Ranga_The_Donga]

[color=#0000FF]ALTER[/color] [color=#0000FF]TABLE[/color] Sales.SalesOrderHeader [color=#0000FF]NOCHECK[/color] [color=#0000FF]CONSTRAINT[/color] [color=#0000FF]ALL[/color]
[color=#000000]write ur Update script [/color]
[color=#0000FF]ALTER[/color] [color=#0000FF]TABLE[/color] Sales.SalesOrderHeader [color=#0000FF]CHECK[/color] [color=#0000FF]CONSTRAINT[/color] [color=#0000FF]ALL[/color]
First tables meedha vunna constraints disable chesthuna.......no need to drop.. Write ur update script. Malli constraints anni activate chesthuna... Hope dis shd works...

[Bhayya]

Constaint drop cheyyakarledu. Disable cheyyocchu.