Hugo Kornelis (5/6/2013)

---

And finally, to Steve - I know we've discussed this before, and I know it won't happen, but I just have to ask again. Can you please, please,...

malleswarareddy_m (4/26/2013)

---

Thanks for nice question.

---Statement 1

CREATE TABLE #table1

(

ID int PRIMARY KEY,

Name varchar(20)

CONSTRAINT UN_Name UNIQUE(Name)

);

CREATE TABLE #table2

(

ID int PRIMARY KEY,

PersonName varchar(30) REFERENCES #table1(Name)

);

go

select * from #table1

select * from...

An interesting article, but IMO it would be even better if you stated what you wanted: "...to replace the entire block of records for ID=2" in the introduction, or at...