| Author: Mohan Kumar 24 Nov 2006 | Member Level: Diamond | Rating:  Points: 2 |
hi,
increment means? i can't get you.
|
| Author: G. Ramya Krishna 24 Nov 2006 | Member Level: Silver | Rating: Points: 2 |
Hi,
You want to generate a number to the userid automatically the next number.
If yes follow the beloew code.
Declare @UserID int
set @UserID = (Select Max(eno) from emp)
set @UserID =@UserID +1
insert into Users(UserId,Username)
values(@UserID ,'xyz')
If no, Give your exact requireemnt. So that we can help you.
|
| Author: Rajaraman 24 Nov 2006 | Member Level: Diamond | Rating: Points: 2 |
use userid filed as identity
|