select
ClassName,Path,HaveBaby,
LinkURL=case LinkURL
when '' then ''
else '<a href='+LinkURL+' target="_blank"><font color="#0066FF">[外部链接]</font></a>'
end
,ID from Class order by RootID,OrderID
是表示select ClassName,Path,HaveBaby,LinkURL ,ID from Class order by RootID,OrderID
还是表示select ClassName,Path,HaveBaby,“<a href='+LinkURL+' target="_blank"><font color="#0066FF">[外部链接]</font></a>”,ID from Class order by RootID,OrderID
呢?就是LinkURL=case LinkURL
when '' then ''
else '<a href='+LinkURL+' target="_blank"><font color="#0066FF">[外部链接]</font></a>'
end
这里不太好理解,谢谢大家帮忙
ClassName,Path,HaveBaby,
LinkURL=case LinkURL
when '' then ''
else '<a href='+LinkURL+' target="_blank"><font color="#0066FF">[外部链接]</font></a>'
end
,ID from Class order by RootID,OrderID
是表示select ClassName,Path,HaveBaby,LinkURL ,ID from Class order by RootID,OrderID
还是表示select ClassName,Path,HaveBaby,“<a href='+LinkURL+' target="_blank"><font color="#0066FF">[外部链接]</font></a>”,ID from Class order by RootID,OrderID
呢?就是LinkURL=case LinkURL
when '' then ''
else '<a href='+LinkURL+' target="_blank"><font color="#0066FF">[外部链接]</font></a>'
end
这里不太好理解,谢谢大家帮忙
如果:
LinkURL 等于 '' LinkURL = ''
否则:
LinkURL = '<a href='+LinkURL+' target="_blank"><font color="#0066FF">[外部链接]</font></a>'