通过sql case when对商品表自定义属性进行查询，实现行专列效果。 declare @sql varchar(8000)set @sql=select stylenoselect @sql=@sql+,+[a_goodsattr].attrname+=isnull(max(case attrname when +[a_goodsattr].attrname+ then attrvalue end),0) from a_
通过sql case when对商品表自定义属性进行查询，实现行专列效果。
declare @sql varchar(8000)set @sql='select styleno'select @sql=@sql+','+[a_goodsattr].attrname+'=isnull(max(case attrname when '''+[a_goodsattr].attrname+''' then attrvalue end),0)' from a_goodsattr order by attrid set @sql=@sql+' from a_proattrlist where 1=1 and styleno=''100010'' group by styleno order by styleno'print @sqlexec(@sql)
1、全部商品自定义属性
2、单货号自定义属性