niha
01-29-2008, 01:51 PM
Hi everyone,
I need to create a trigger so please help me with the syntax
Data is inserted in table_1 "users", whenever that happens i need some of this data to get inserted right away in table_2 "community" , one of this filed that should be inserted in table 2 is the id field generated in table_1 how can i do that???
CREATE TRIGGER tg_feedCommunity ON [users]
FOR INSERT
AS
Insert into community (iduser,nickname, email) values ( DRIVEN FROM TABLE_1)
thanks in advance
Niha
I need to create a trigger so please help me with the syntax
Data is inserted in table_1 "users", whenever that happens i need some of this data to get inserted right away in table_2 "community" , one of this filed that should be inserted in table 2 is the id field generated in table_1 how can i do that???
CREATE TRIGGER tg_feedCommunity ON [users]
FOR INSERT
AS
Insert into community (iduser,nickname, email) values ( DRIVEN FROM TABLE_1)
thanks in advance
Niha