How to Increment Value

declare @tbl table (id int)

Declare @UID int

Declare @UserId int

SET @UID='0'

while (@uid<4)

begin

insert into @tbl select @UID+1

SET @UID = @UID+1;

end

Select * from @tbl

You can set the UserID field as Identity.

Ex:

CREATE TABLE [dbo].[YourTable]

(

UserId [int] IDENTITY(1,1) NOT NULL,

UserName varchar(100) NOT NULL

)

Here it autometically insert one incremeneted value into your table.

Or

At the time of insert you can try this.

Insert into YourTable (UserID, UserName)

values((SELECT ISNULL(max(UserID),0)+1 FROM YourTable), 'YouName').

Both way you can try.

Hi friends

you can declare UserId filed identity on

CREATE TABLE [dbo].[UserRegistration](UserId [int] IDENTITY(1,1) NOT NULL,

[UserName] [nvarchar](15) NOT NULL,)

Use identity column

https://www.w3schools.com/sql/sql_autoincrement.asp