Small Question On Sql

[AFDBAbhimanini]

yes/....correct adhe chedham anukuntuna kani A table kuda C table ki linked undhi...so adhi allow cheyaledhu... 

 

its A---b --C--- A ..... so dentlo chesina conflict avuthundhi FK vala

Assalu ala ela??? howwwww???????  :3D_Smiles:  :3D_Smiles:  .. Requirement emi???

 

 

we need DB experts   ltt

[k2s]

[rapchik]

constraints tesesi insert chey after everything is inserted constraints pettu

constraints ella testhav??

[AFDBAbhimanini]

constraints tesesi insert chey after everything is inserted constraints pettu

   inka constraints endhukuuuuu

[suthivelu]

constraints ella testhav??

alter table
   table_name
DISABLE constraint
   constraint_name

 

alter table

   table_name
ENABLE constraint
   constraint_name;

[suthivelu]

   inka constraints endhukuuuuu

insert chesa apudu constraints disable cheyali ilage errors vastay once everything is loaded enable them dats it 

[tom bhayya]

alter table
   table_name
DISABLE constraint
   constraint_name

 

alter table

   table_name
ENABLE constraint
   constraint_name;

 

 

insert chesa apudu constraints disable cheyali ilage errors vastay once everything is loaded enable them dats it 

:3D_Smiles:

[AFDBAbhimanini]

insert chesa apudu constraints disable cheyali ilage errors vastay once everything is loaded enable them dats it 

[k2s]

syntax overview

There are two types of multi-table insert as follows:

• INSERT FIRST; and
• INSERT ALL.

Multi-table inserts are an extension to INSERT..SELECT. Syntax is of the following form:

INSERT ALL|FIRST
[WHEN condition THEN] INTO target [VALUES]
[WHEN condition THEN] INTO target [VALUES]
...
[ELSE] INTO target [VALUES]
SELECT ...
FROM source_query;

We define multiple INTO targets between the INSERT ALL/FIRST and the SELECT. The inserts can be conditional or unconditional and if the record structure of the datasource matches the target table, the VALUES clause can be omitted. We will describe the various permutations in this article.

 

source : http://www.oracle-developer.net/display.php?id=209

 

 

my $0.01

[rapchik]

insert chesa apudu constraints disable cheyali ilage errors vastay once everything is loaded enable them dats it 

its not a constarint antudhi systemmm.,,,

 

Msg 3728, Level 16, State 1, Line 1

'User_Division_ID' is not a constraint.

Msg 3727, Level 16, State 0, Line 1

Could not drop constraint. See previous errors.

[suthivelu]

:3D_Smiles:

am i wrong?

[Suhaas]

syntax overview
There are two types of multi-table insert as follows:

• INSERT FIRST; and
• INSERT ALL.

Multi-table inserts are an extension to INSERT..SELECT. Syntax is of the following form:
INSERT ALL|FIRST
[WHEN condition THEN] INTO target [VALUES]
[WHEN condition THEN] INTO target [VALUES]
...
[ELSE] INTO target [VALUES]
SELECT ...
FROM source_query;
We define multiple INTO targets between the INSERT ALL/FIRST and the SELECT. The inserts can be conditional or unconditional and if the record structure of the datasource matches the target table, the VALUES clause can be omitted. We will describe the various permutations in this article.

source : http://www.oracle-developer.net/display.php?id=209


my $0.01

MS SQL Server lo inka raledhu bhayya INSERT FIRST and INSERT ALL support

[AFDBAbhimanini]

 

its not a constarint antudhi systemmm.,,,

 

Msg 3728, Level 16, State 1, Line 1

'User_Division_ID' is not a constraint.

Msg 3727, Level 16, State 0, Line 1

Could not drop constraint. See previous errors.

 

kudirithe aa 3 tables ddl lu extract chesi pampu.....

[amsuraj]

 

its not a constarint antudhi systemmm.,,,

 

Msg 3728, Level 16, State 1, Line 1

'User_Division_ID' is not a constraint.

Msg 3727, Level 16, State 0, Line 1

Could not drop constraint. See previous errors.

 

 

This is not correct way...try to insert data first in parent table (which has primary key) and then try to insert related data in child tables(which has foreign key)

[suthivelu]

 

its not a constarint antudhi systemmm.,,,

 

Msg 3728, Level 16, State 1, Line 1

'User_Division_ID' is not a constraint.

Msg 3727, Level 16, State 0, Line 1

Could not drop constraint. See previous errors.

 

nuvvu insert chess values anni unique ena? okasari table constraints anni check chey