Field That Will Automatically Be Increased By 1 Whenever SELECT Is Called. How To Do It?

i have a field Count that i want it to be automatically increased by 1 whenever a SELECT stament is called. i come out with the following sql query and it works on SQL Query Analyzer:





declare @count int


select @count = count+1 from pictures_posts where itemtype='3'


update pictures_posts set count=@count where itemtype='3'


select postID, color, count from pictures_posts where itemtype='3'


go








but i am thinking it must be a much better to do this. can you guys help?