Asp.text EmpID Automatic generation

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