Archives of the TeradataForum

Message Posted: Tue, 17 Feb 2004 @ 11:54:17 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

I want to create a AFTER INSERT FOR EACH ROW tigger on a table. But in the trigger code i want to use SELECT INTO query to select some data from a table and store in a variable for some calculation.Can we use SELECT INTO query and if yes the how to declare variables in triggers.

Regds,

Anuradha Mehra.

	<Prev	Next>		<<First	<Prev	Next>	Last>>