解决方案 »
- 问个数据库用户的问题
- 帮忙解释一条语句if not exists(select 1 from deleted d join inserted i on d.ID=i.ID and d.col1=1 and i.col1=2)
- sql server 2005 安装的问题
- 有关递归???急
- 简单问题 #ProcLines 请问是什么?? object_id(@vchObjectName) 是什么??
- 如何将带制表符的文本文件导入到SQL表中
- 安装SQL2000的时候出错?!!!
- sqlserver恢复日志
- 请教高手:学用pb6和oracle8i作项目,应该先学pb还是oracle?
- 高手们,这样的存储过程可以实现吗?
- 使用域用户用户名和密码登陆mssql
- 请问 关于32位server2003系统32位2005数据库 移植到64位server2008系统64位2005数据库的问题
SUM(a.seremit_f) AS seremit_f ,
SUM(a.seaccept_t) AS seaccept_t ,
SUM(a.seaccept_f) AS seaccept_f ,
SUM(a.secash_t) AS secash_t ,
SUM(a.secash_f) AS secash_f
FROM dbo.tb_Periodstart AS a
WHERE a.deptclass IN ( 108, 107, 106 )
AND CONVERT(VARCHAR, DATEADD(dd, 1, a.ctdate), 23) = '2014-04-10'
GROUP BY a.id
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
菜鸟 靠边....
你看到查询里边 有id 字段吗? 查询窗口 跟数据表窗口貌似很不一样啊..这应该是常识吧.
不过查询分析器也没有报错...这就是我感觉计较困惑的地方..
sorry 了................不管怎样 多谢.
[email protected]
QQ 1005524346
[email protected]
QQ 1005524346Profiler工具是sqlserver 最晚从2000就自带的工具,不是什么第三方软件
这个东西吗? 我慢慢调试吧..我觉得你用java调试更方便
这个查询"SELECT sID,sText from tb_compney where sID IN ("+deptClass+");";
事件探查器显示 如下
SELECT sID,sText , * from tb_compney where sID IN (10202);
就是这个的原因.
原语句变成这个了
SELECT Sum(a.seremit_t) AS seremit_t,Sum(a.seremit_f) AS seremit_f,Sum(a.seaccept_t) AS seaccept_t,Sum(a.seaccept_f) AS seaccept_f,Sum(a.secash_t) AS secash_t,Sum(a.secash_f) AS secash_f , * FROM dbo.tb_Periodstart AS a WHERE a.deptclass IN (10202) and CONVERT(VARCHAR, dateadd(dd,1,a.ctdate), 23)='2014-04-10'
有 , * 啊