I would like to write a MS-SQL Server TRIGGER based on a particular Field value and not sure if it is possible or not.
For example if (and Only if ) someone or any application has insert a record with a certain field (e.g. Field A) value is "U", then this event will fire this trigger, is it possible on MS-SQL ?
My company are using an MS-SQL Server 2008 Express Edition.
Thank you so much for your help in advance.