create Function T_Test() returns varchar(8) as begin declare @ID varchar(8) select right(cast(100000001+isnull(max(filed1),0) as varchar),8) from Tb return @ID end
declare @t table(id varchar(8)) insert into @t select 'A'+right(10000001+isnull(right(max(id),7),0),7) from @t insert into @t select 'A'+right(10000001+isnull(right(max(id),7),0),7) from @t insert into @t select 'A'+right(10000001+isnull(right(max(id),7),0),7) from @t insert into @t select 'A'+right(10000001+isnull(right(max(id),7),0),7) from @t insert into @t select 'A'+right(10000001+isnull(right(max(id),7),0),7) from @tselect * from @t--可以写成一个函数,作为改列的默认值
returns varchar(8)
as
begin
declare @ID varchar(8)
select right(cast(100000001+isnull(max(filed1),0) as varchar),8) from Tb
return @ID
end
insert into @t select 'A'+right(10000001+isnull(right(max(id),7),0),7) from @t
insert into @t select 'A'+right(10000001+isnull(right(max(id),7),0),7) from @t
insert into @t select 'A'+right(10000001+isnull(right(max(id),7),0),7) from @t
insert into @t select 'A'+right(10000001+isnull(right(max(id),7),0),7) from @t
insert into @t select 'A'+right(10000001+isnull(right(max(id),7),0),7) from @tselect * from @t--可以写成一个函数,作为改列的默认值