ASp.net employee id automatic generation using sql

Question

Hi,
In my application i have empid column,,,in that id should come as max(empid)+1  from database automatically,my database is sql server can u plz suggest the query for my problem,,,


Thanx in Advance,


Regards,
Sathish Pabbathi