CREATE procedure [dbo].[proc_packing_set]
(@whereSql varchar(1000))
as
begin
select order_no from tbl_packing_set + @whereSql +group by order_no可恶的CSDN,我昨晚回复,到今天早上来回复,还说我回复得太快.
(@whereSql varchar(1000))
as
begin
select order_no from tbl_packing_set + @whereSql +group by order_no可恶的CSDN,我昨晚回复,到今天早上来回复,还说我回复得太快.
(@whereSql varchar(1000))
as
begin
exec('select order_no from tbl_packing_set '+ @whereSql +' group by order_no ')
CREATE procedure [dbo].[proc_packing_set]
(@whereSql varchar(1000))
as
begin
exec('select order_no from tbl_packing_set' + @whereSql +'group by order_no')
end
(@whereSql varchar(1000))
as
begin
exec ('select order_no from tbl_packing_set '+ @whereSql +'group by order_no')
end
(@whereSql varchar(1000))
as
exec('select order_no from tbl_packing_set '+ @whereSql +' group by order_no ')
(@whereSql varchar(1000))
as
begin
declare @sql nvarchar(4000) set @sql='select a.box_size,b.box_desc as 箱型' Select @sql=@sql+',sum(case when actual_size='''+actual_size+ ''' then qty else 0 end) As '''+actual_size+''''
From tbl_packing_set a +@whereSql + group by order_no,product_no,actual_size set @sql=@sql+' From tbl_packing_set a left join tbl_parameter_box_size b on a.box_size=b.box_size ' +@whereSql +
'Group By a.order_no,a.product_no,a.color_id,a.box_size,b.box_desc'
execute sp_executesql @sql
这个呢?