insert ddDepotD(F_Code,F_goodcode,F_goodname,f_spec,f_unit,f_Amount,f_price,f_rate,F_TotalPrice) select 'T_ACD0001',[f_code],[f_name],[f_spec],[f_unit],[f_number],[f_dj],[f_rate],[f_sum] from tempDdGood
如果tempDdGood表没有任何数据如何将 'T_ACD0001' insert到表ddDepotD
如果tempDdGood表没有任何数据如何将 'T_ACD0001' insert到表ddDepotD
但是我的意思是tempDdGood表没有任何数据时 可以插入 F_Code='T_ACD0001' 值其余可以为null
values (select 'T_ACD0001',[f_code],[f_name],[f_spec],[f_unit],[f_number],[f_dj],[f_rate],[f_sum] from tempDdGood)
select 'T_ACD0001' where not exists (select 1 from tempDdGood)
if exists (select 1 from tempDdGood)
insert ddDepotD(F_Code,F_goodcode,F_goodname,f_spec,f_unit,f_Amount,f_price,f_rate,F_TotalPrice) select 'T_ACD0001',[f_code],[f_name],[f_spec],[f_unit],[f_number],[f_dj],[f_rate],[f_sum] from tempDdGoodelse insert ddDepotD(F_Code) values('T_ACD0001')