丁
丁丁小
Unregistered / Unconfirmed
GUEST, unregistred user!
执行以下语句时报错：<br>insert into tSystemConfig <br><br>(QueryData,QueryFile,UserID,Quantity,Charge,Total,Faith,HurryData,<br>HurryFile,HurryTime,NormalCash,NormalMonth,NormalStart,NormalEnd,SpecialCash,<br>SpecialMonth,SpecialStart,SpecialEnd,RingCount,LinkType,Appeal,Repair,<br>Consultation,Wrong,HintType,NotifyType,DataCollectionConnStr,FetchDataSqlStr,<br>NormalStartDay,NormalEndDay,SpecialStartDay,SpecialEndDay,SpecialEndDay,SpecialSms,<br>CutoffSms)<br><br>VALUES <br><br>(TXT,C:/CallCenter/Service/charge.txt,USERID,1,1,1,1,TXT,C:/CallCenter/Service/charge.txt,<br>2000-1-1 15:30:00,0,1,2000-1-1 8:00:00,2000-1-1 18:30:00,0,1,2000-1-1 8:00:00,<br>2000-1-1 18:00:00,2,PICKUP,1,2,3,4,DEFAULT,TTS,user ID=system; password=manager; Data Source=eerp; persist security info=false,<br>SELECT (SELECT USER_TYPE FROM YH_USER WHERE USER_ID = f_cur_us.总户号) AS 用户类型, (SELECT COUNT(*) FROM DF_USER_FEE WHERE (USER_ID = f_cur_us.总户号) AND (STATUS = '未') AND (POWER_VALUE > 0) AND (POWER_CHARGE > 0)) + 1 AS 欠费月数, 总户号, (SELECT PHONE FROM YH_USER WHERE USER_ID = f_cur_us.总户号) AS 电话, (电费年 + 电费月) AS 发生年月, 合计电量, 合计电费, 滞纳金, (SELECT SUM(DUE_CHARGE - PAID_CHARGE) FROM DF_CUR_USER WHERE DF_CUR_USER.USER_ID = f_cur_us.总户号) AS 欠费,(SELECT USER_NAME FROM YH_USER WHERE USER_ID = f_cur_us.总户号) AS 用户名 FROM f_cur_us,<br>1,10,1,10,0,0,1)<br><br>报错信息如下：<br>服务器: 消息 128，级别 15，状态 1，行 12<br>在此上下文中不允许使用 'TXT'。此处只允许使用常量、表达式或变量。不允许使用列名。<br>服务器: 消息 132，级别 15，状态 1，行 12<br>标签 'C' 已声明。标签名称在批查询或存储过程内部必须唯一。<br>服务器: 消息 170，级别 15，状态 1，行 16<br>第 16 行: '1' 附近有语法错误。
]