id incrementation

Question

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.