I need to generate a next number value from a SQL Server table. I need to ensure that the number is unique and that another user doesn't retrieve the same value from the next number table.

What is the best way to generate a next number value from a SQL Server table?

Thanks,

Jerry