Is there any code to increment the Userid Numbers....

While making the SQL Table, you can make the required column Autoincrement(Identity=true), the column must be of int datatype. Then when ever the data is inserted into the table. The column automatically increment the set value.

try to create this table.

CREATE TABLE [dbo].[testtable](
	[userid] [int] IDENTITY(1,1) NOT NULL,
	[username] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Thanks

You can set an auto-increment option while designing the table.
This will automatically increment the value everytime a row is inserted.

Try
http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/[^]
http://www.sitepoint.com/forums/showthread.php?41676-Auto-Increment-primary-key-in-MS-SQL-server[^]

this is demo but but it is useful for Auto ID

create table #tblTest(UserId  int,UserName varchar(50))

insert into #tblTest(UserId,UserName)
select isnull(max(UserId),0)+1,'Your Use Name' from #tblTest

select * from  #tblTest
drop table #tblTest