How to Increment Value

Question

Declare @UID varchar(30)

Declare @UserId varchar(50)

SET @UID='0'

SET @UserId = @UID+1;

Select @UserId as U

 

I want To Know  How   Increment value  on Every Execute  

Like

1

2

3

4

 

so please help me