Create a trigger to update a record

How can I create a trigger to update rating to rating+1 if audio=‘choose one format’ ?
The database model i located below
The query is prefered in ** SQL Server.**

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.