SQL Script Example - Increment A Column Value Up by 1

This is a simple way to increment a column count.  It is very reliable since we are incrementing the value of the column using its own value.

UPDATE [MyTable]
SET [myColumnCount]=[myColumnCount] + 1
WHERE [id]=@rowid;