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.