修改一句ASP中的SQL语句（如何在From的前面不再有逗号出现）

来源：百度知道编辑：UC知道时间：2024/06/06 06:45:02

错误示范：
set loc=conn.execute("SELECT DISTINCT LocationCode FROM Dim_Location ")
sql= "select Dim_SKU.SKU,Dim_SKU.SKUDesc,"
do while not loc.eof
strlocationcode=loc("LocationCode")
if loc.eof then
sql=sql & "sum(case when LocationCode='"& strlocationcode &"' then totalqty else null end ) as "& strlocationcode &"qty"
else
sql=sql & "sum(case when LocationCode='"& strlocationcode &"' then totalqty else null end ) as "& strlocationcode &"qty,"
end if
loc.movenext
loop
sql=sql & " From HKSOH "
sql=sql & " inner join Dim_Location on HKSOH.Location=Dim_Location.LocationCode "
sql=sql & " inner join Dim_SKU on HKSOH.SKU=Dim_SKU.SKU "
sql=sql & " where HKSOH.SKU like '"&sku&"%' "
sql=sql & " group by Dim_SKU.SKU , Dim_

不要IF判断，最后完毕后删除最后的逗号就行了，例如：
do while not loc.eof
strlocationcode=loc("LocationCode")
sql=sql & "sum(case when LocationCode='"& strlocationcode &"' then totalqty else null end ) as "& strlocationcode &"qty,"
loc.movenext
loop
sql=left(sql, len(sql)-1) '核心就是这一句

有没有分都无所谓，关键是希望对你有一点点帮助～

[asp求助]一句sql语句请教! ASP sqL修改语句 asp中的sql语句? 一句sql语句 asp中的sql语句错误 asp中的sql语句问题求教一句SQL语句！求助一句SQL语句。 asp中的一句SQL问题,高手请进. 求助~!asp中的sql查询语句~!