delphi 中sql 语句 sql:='select * from dw where dwmc='+ dwmc 这么写不对
sql:='select * from dw where dwmc='''+ dwmc +''' 这么写也不对到底怎么写dwmc是一个字符型的变量 数据库用的sql server2008
sql:='select * from dw where dwmc='''+ dwmc +''' 这么写也不对到底怎么写dwmc是一个字符型的变量 数据库用的sql server2008
SQL:='select * from dw where dwmc='+#39+dwmc+#39
sql:='select * from dw where dwmc='''+ dwmc+'"'
sql:='select * from dw where dwmc=''+dwmc+'''
2.用QuotedStr,就不用考虑引号的问题啦
sqlstr:='select * from dw where dwmc='''+ dwmc+'"';
sqlstr:='select * from dw where dwmc='''+ dwmc+'"';
用format就是sqlstr:=format('select * from dw where dwmc=''%s''', [dwmc]);%s是指字符型,如果是整形的就是%d format('select * from dw where dwmc=%d', [dwmc]);,浮点型的就是%f format('select * from dw where dwmc=%f', [dwmc]);
sql:='select * from dw where dwmc='+ dwmc 这么写不对
sql:='select * from dw where dwmc='''+ dwmc +''' 这么写也不对正确的语法是:sql:='select * from dw where dwmc='+'''+ dwmc+''';
或:sql:='select * from dw where dwmc='+QuotedStr(dwmc);第二.SQL SERVER 2008的语法问题
SQL SERVER 2008是否存在字段大小写问题(我没有研究过SQL SERVER 2008),但甲骨文是区分大小写的,这一点你注意。你如果有exception的提示框截图,就好判断了