如何在SQL Server 2005中保证事务完整性

I have what looked to me at first glance a very simple problem. I want to be able to obtain a unique key value with a prefix. I have a table which contains 'Prefix' and 'Next_Value' columns.I have what looked to me at first glance a very