可以,下面是一条动态显示图片的sql语句案例
SELECT a=' <a href=''../gt_use/product.aspx?type=new&style_no='+ A.style_no +'&image_name='+ replace(isnull(image_name,''),'.','@@') +''' onClick=openWindow() target=''PUList''> <IMG src=''../gtShare/photo/Icons/'+isnull(image_name,'')+''' border=''0'' > <br>
<FONT size=2> <a target=''PUList''>'+A.style_no+' <br>排名:'+cast(sort_id as varchar)+' <br>销售数量:'+cast(num as varchar)+' </a> </FONT>'
FROM #temp A
INNER JOIN #temp2 B ON A.style_no=B.style_no
ORDER BY A.id
可以,下面是一条动态显示图片的sql语句案例
SELECT a=' <a href=''../gt_use/product.aspx?type=new&style_no='+ A.style_no +'&image_name='+ replace(isnull(image_name,''),'.','@@') +''' onClick=openWindow() target=''PUList''> <IMG src=''../gtShare/photo/Icons/'+isnull(image_name,'')+''' border=''0'' > <br>
<FONT size=2> <a target=''PUList''>'+A.style_no+' <br>排名:'+cast(sort_id as varchar)+' <br>销售数量:'+cast(num as varchar)+' </a> </FONT>'
FROM #temp A
INNER JOIN #temp2 B ON A.style_no=B.style_no
ORDER BY A.id