How come you are saying Cascade is normal on update/delete. By default it will be No Action rite?

I think he is expecting us to think in normal scenario.. We shud not think beyond that..

thanks..

pls xplain wat does breaking of relationship means?

wat does this mean "Breaking of relationships is prevented once referential integrity on a database is enforced".

We can delete a row in primary table if CASCADE option is chosen On DELETE rite?

Thanks Man.

Can u tell me what will be default mode of "XACT_ABORT" in sql server. If i'm setting it as ON then how long it will be effective.

Hi Guys,

Can anyone explain how two rows will be inserted. I tried the same and for me only first record is getting inserted.

create table T1 (a int not null,b char(1)...