foreach loop in sql server trigger
Posted on 2014-03-21
I have a table with 50 columns . I need to store insert ,update log in audit table.
for that i am writing triggers.
insert into HC_Audit
can anyone help me to run for each loop to get column name and column value so that i can insert data into hc_Audit table from insert , update , delete trigger .