Prev: SQL Server 2000 log shipping monitor
Next: Create text file
From: Jay on 5 Dec 2009 13:31
> Adding to others comments, I think you will need a trigger on table B to
> roll back any attempt to insert more than one (or a second+) record there
> for a given tableA PK.
>

No trigger. If he really has a 1-1 relationship, then:

Table A {
ID int identity(1,1) primary key
Name varchar(20) not null
}

Table B {
ID int primary key
Type varchar
foreign key ID references Table A
}

But you would really, Really, REALLY need to have a need for a 1-1
relationship between tables A & B.


First  |  Prev  | 
Pages: 1 2
Prev: SQL Server 2000 log shipping monitor
Next: Create text file