Hi All,

The following are the references that were used in the write up for the article.

It has been missed during the compliation of the article.Please refer to the reference for further details.

REFERENCES

Isn't there an error in the first example?  Shouldn't the last record in tblsection join to the 4, Test record in tblModule? 

I think that you didn't mean to insert the 4, TEST record into tblModule, correct?

D'Arcy

Great article!

I particularly enjoy the OUTPUT clause.  One of the thing that I bi***, er, gripe about is data archiving.  It is usually left out of designs until the server fills up.   This will be a great boon as I can now write my archive function with only one statement per table and wrap the whole thing in a transaction.  My archive database is an exact copy, structurally, of the production database.

You are right D'Archy .The section table should not be populated with the records for Module 4.

Apologies for that ..Just execute the following script and it should give you the desired results

delete from tblsection where fk_moduleid=4

Thanks for your comments

Good Article, easy to read and understand.