So, what I did is this:
DECLARE @ViewsCount int
SELECT @ViewsCount = [Views] FROM Project WHERE Oid='FAD06A96-ABE8-4A8F-81ED-07235EE813FC' AND ProjectName='My Project'
UPDATE Project
SET [Views] = (@ViewsCount + 1)
WHERE Oid='FAD06A96-ABE8-4A8F-81ED-07235EE813FC' AND ProjectName='My Project'
I am declaring int variable and then setting the value of that variable with a select query.
Once the variable has the value I am updating the field in the table.
That's all!
The field is now incremented each time that SP will be called.
Thanks for reading.