Create a trigger in sql

how too?

[Miggel]

Can anyone help me i need too create a trigger in sql that will show the ID that is given too a item when i insert or update it

Thanks,

Miggel

[IanTurner]

In the Table insert trigger, put the statement

Select @ItemID = ItemID from Inserted

definitely works for SQL Server.

[Miggel]

i will try it

thanks