執行了下面腳本，提示列明#StartDate# 和#EndDate# 無效。請教一下怎么修改
非常感謝！<command key="WelfareHzwyPosData.Select">
<![CDATA[
select
c.LoginID UserLoginId,
c.UserName UserName,
c.DPFullName DPFullName,
c.CardID UserInnerUID,
a.PeriodType PeriodType,
a.PosTime RunningAccountTime,
a.PosTime PosTime,
a.PosRegionID PosRegionID,
a.DevName DevName,
a.PosMoney CostMoney,
a.AccountPosDataID ToRunningAccountId,
a.CreateTime CreateTime
from [Pos_AccountPosData] a
left join Pos_CardInfo b ON b.CardNo = a.CardNo
left join Sys_User c ON b.CardUserID=c.UserID
where a.CreateTime between #StartDate# and #EndDate#
order by a.PosTime
]]>
</command>
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/248324.html
標籤：基礎類
上一篇：魔術師發牌，大佬看看代碼有啥問題
下一篇：帶小數點的資料查詢篩選問題