Trigger - Insert Values

[Guest_imported]

Hi,

I have a main table CONTACT with a counter as the key. I want to write a trigger that, everytime a row is created in this main table CONTACT, a new row is inserted in an annex table with the number generated as the value of a column.

For example, if the following row is inserted in the main table CONTACT:

Generated number
|
v
22 John Smith

So a trigger insert the following row in another table:

22 2001/06/18

Is it possible ? How ?

Thanks

Vincent

 

[tlbroadbent]

The MS SQl Server syntax is...

Create Trigger trgInsertAnnexRow On tbl For Insert As

Insert AnnexTbl (RecID, InsertDateTime)
Select RecID, getdate() From inserted


Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost