a trigger question

Hello,I am newcomer to the list.I have a question about mysql trigger.There is a
table named test and an insert trigger connected to the table.table temp is a copy
of table test,it records the columns inserted into test using the insert trigger.
I have read the manual,and created a trigger like this: 

CREATE TRIGGER trigger_insert after INSERT ON test  FOR EACH ROW BEGIN  INSERT
INTO temp SET a1 = NEW.a1;

It seems like you have to specify the colunms in the SET substatement. Is there
something like "select * from inserted" in mssql ,so that I don't need to specify
the column name like "a1 = NEW.a1" staticly?

thanks in advance 
marilynchai




-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]