Question: a select count(1) from inserted ill return the number of inserted rows?

just for the record: avoid triggers, they are evil.

avoid to put business logic in the database, let the application to handle it in the appropriate layer.