else if @sign=0
begin
set @primarykey = @tmpword+ @year1 + @month1 + @day1 + @tmpprenum
end
else
begin
raiserror ('parameter error', 16, 1)
end
--------------------------------------------------------------------------
go
-------------------------------------------------------------------
-- 测试
declare @mybillno varchar(12)
exec getno 'pg', @mybillno output,0
-- if exists (select * from tbrecno where word = left(ltrim(rtrim( @precrecord )),2))
