SQL Server : trigger on not inserted row <p>I have two tables. I have defined a trigger on Table A that updates Table B when a row is inserted into Table A. </p> <p>I want to prevent inserting into table A and allow updating in table B if a data with certain values is sent to Table A.</p> <p>Can anyone help me?</p>