thanks, this is a good example for those who have limited knowlege of .net.

We are getting the same alert.Would like to know the cause of this.

not yet,in few weeks.

try this

declare @col1 int

update dbo.tablename

set  @col1 = col1 =isnull(Col1,0)+1

from   dbo.incrementBYone

where anyfiled to identify the row = 1

select @col1

try @col1 = @col1 = col1+1

where type = @01