om.microsoft.sqlserver.jdbc.SQLServerException: '1' 附近有语法错误。
sql.append("insertintoPayDetail(PayDate,StaffID,BranchID,BasicPay,MeritPay,LeavingDay...
sql.append("insert into PayDetail(PayDate,StaffID,BranchID,BasicPay,MeritPay,LeavingDay,DeductPay,RealityPay) values('"+PayDate+"','"+dtm.getValueAt(i, 0)+"','"+dtm.getValueAt(i, 2)+"',"+dtm.getValueAt(i, 3)+","+dtm.getValueAt(i, 4)+","+dtm.getValueAt(i, 5)+","+dtm.getValueAt(i, 6)+","+dtm.getValueAt(i, 7)+");");
sql.append("select distinct * into 1 from PayDetail;");
sql.append("delete from PayDetail;");
sql.append("insert into PayDetail select * from 1;");
sql.append("drop table 1;");
}
哪里出了错误呀！ 展开
sql.append("select distinct * into 1 from PayDetail;");
sql.append("delete from PayDetail;");
sql.append("insert into PayDetail select * from 1;");
sql.append("drop table 1;");
}
哪里出了错误呀！ 展开
1个回答
展开全部
1不能作为表名....你的表名如果真叫1，那就要加上[]
select distinct * into [1] from PayDetail
select distinct * into [1] from PayDetail
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
