如果SQL Server中的事务失败，触发器是否回滚?

I have some triggers on some tables that perform a function when something is deleted or updated. During a transaction, if the trigger executes and later in the transaction it gets rolled back, does the trigger also get rolled back?I have some triggers on some tables that perfor