Loading

id incrementation

Pooja Chowdhury

10y860

i want that the userid is auto incremented

bsed on

SELECT @UserID=(MAX(UserID) + 1) FROM [User]

but 1st time how to userid will insert 1 respect of userid.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Ranjit Powar10y ago
Try below query
SELECT @UserID=ISNULL(MAX(UserID),0 )+1 FROM [User]
Above query gives 1 when there is no record in table