###这个存储过程怎么理解?
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
这里不太好理解,谢谢大家帮忙