Employers - Post Free Jobs
Forum guidelines
  • Home
  • »
  • SQL Server
  • »
  • How can we set auto increment value of primary key through query
AuthorQuestion
How can we set auto increment value of primary key through query
Posted on: 26 Jul 2012
How can we set auto increment value of primary key through query ?

AuthorReply
Re: How can we set auto increment value of primary key through query
Posted on: 26 Jul 2012  
declare @key int
Select @key=Isnull(MAX(UseriD),0)+1 from tbl_user
insert into tbl_user values(@key,'username','xxxxx')

Thanks & Regards,
Santhosh

Please mark this answer as accepted answer if it resolves your problem.

SPONSORED BY

Offshore Software and Database Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.