紧急 求助!!sql 函数值如何返回
declare @inv_code NVARCHAR(20)
declare @comp_code NVARCHAR(20)
declare @copy_code NVARCHAR(10) --生成批次码必备条件
set @inv_code='QEXX001000070'
set @comp_code='3235'
set @copy_code='001'
declare @bar_dode_auto nvarchar(100)
declare @equi_card_code nvarchar(100)
--遍历临时表
declare @sql nvarchar(4000)
set @sql=''
DECLARE cu_id CURSOR FOR select equi_card_code from equi_bar_code_own_one
where is_bar_code=1 and comp_code=@comp_code and copy_code=@copy_code
order by order_code asc
OPEN cu_id
fetch next from cu_id into @equi_card_code
WHILE(@@FETCH_STATUS = 0)
begin
--遍历临时表中的数据,和字段进行对比,如果存在就将传入的值,组装成批次吗
set @sql= @sql+' dbo.getspellcode(isnull('+@equi_card_code+' ,'''' ),'''')+'
fetch next from cu_id into @equi_card_code
end
close cu_id
deallocate cu_id
-- print @sql
set @sql=left(@sql,len(@sql)-1)
set @sql=' select @bar_dode_auto='+@sql+' from mate_inv_dict where comp_code='''+@comp_code+''' and copy_code='''+
@copy_code+''' and inv_code='''+@inv_code+''''
-- select @sql
--select @bar_dode_auto
--select @sql