一条SQL语句的长度有什么限制吗
2个回答
展开全部
把字符串拆开~引号里的长度有限制，拆成连个引号，再连接起来
SQLstr = "select iperiod 会计期间,ino_id 凭证编号,iflag ,cdigest 摘要,ccode 科目,md 借方金额, mc 贷方金额,cdept_id 部门,ccus_id 客户,ccode_equal 对方科目"
+ " from UFDATA_005_2008.dbo.GL_accvouch WHERE (iflag Is Null) AND (iperiod Between 1 AND 12 ) AND ( ccode =10101)AND ( ccode_equal LIKE '%52102%') order by iperiod,ino_id"
SQLstr = "select iperiod 会计期间,ino_id 凭证编号,iflag ,cdigest 摘要,ccode 科目,md 借方金额, mc 贷方金额,cdept_id 部门,ccus_id 客户,ccode_equal 对方科目"
+ " from UFDATA_005_2008.dbo.GL_accvouch WHERE (iflag Is Null) AND (iperiod Between 1 AND 12 ) AND ( ccode =10101)AND ( ccode_equal LIKE '%52102%') order by iperiod,ino_id"
本回答由网友推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
