SQL留纪念

insert into lei.dbo.price([Barcode],[A_number],[Branch],[Class],[Char1],[Char2],[Char3],[Char5],[no1attribute],[No1time],[No2point],[Nume1_1],[Nume1_2],mbarcode) select item_subno+case when barcode_no1 is null then '' else ','+barcode_no1 end++case when barcode_no2 is null then '' else ','+barcode_no2 end+case when barcode_no3 is null then '' else ','+barcode_no3 end+case when barcode_no4 is null then '' else ','+barcode_no4 end+case when barcode_other is null then '' else ','+barcode_other end,item_no,@i,item_clsno,item_name,item_size,unit_no,product_area,1,getdate(),0,sale_price,vip_price,item_subno from bi_t_item_info WHERE item_no =@item_no