Never wrote any sql procedure, writing my first procedure.

[oslon]

while(true)
{
    if(id==1 && counter.length>7)
    {
        counter.value=1
    }

}

Application_counter

id| counter
1 | 123

Need to convert this to a procedure that runs forever in ms-sql server. How do I do it?

[kicken]

5 hours ago, oslon said:

How do I do it?

You don't, because such a thing doesn't make sense to do.

How about you describe the problem you think this will solve?  Sounds like maybe what you want instead is either a sequence or an identity column.