Create Trigger With Dynamic Columns

See more:

SQL

CREATE TRIGGER TRGI_VW_Table ON VW_Table
INSTEAD OF INSERT
AS
BEGIN
INSERT INTO Table1
SELECT Col1,Col2,Col3,Col4,Col5,Col6,Col7
FROM INSERTED
END

This Code working fine. But Instead of static field i want dynamic field here, like i want to retrieve column name from information_schema.columns.

Can any one help me.