Set the Priority for two different "after insert" triggers in SQL Server
<p>I'm trying to create triggers by functionality, instead of DML operation.</p>

<p>For example, I have 2 triggers A and B. A is for <code>AFTER INSERT, UPDATE, DELETE</code>, and B is for <code>AFTER INSERT</code>.</p>

<p>How can I know which one (A or B) is run first after insert of a new record? </p>