SQL Server 2005中自动获取类似"A100"的存储过程实现
时间：2011-02-21 来源：点灯
as
begin
declare @temp int
if((select count(*) from table_name)=0)
begin
set @out_next_id = 'A100'
end
else
begin
select @out_next_id=max(field_name)
from table_name
set @temp = right(@out_next_id,3)+1
set @out_next_id='A' + cast(@temp as varchar(3))
end
end
相关阅读 更多 +
