Question

Delphi ADOQuery SQL属性中加SQL语句时引号符号怎么弄啊

ADOQuery1.SQL.Text:='CREATE DATABASE 123 on primary( name='123_data',filename='E:\123_data.mdf',size=5mb,maxsize=100mb,filegrowth=15%) log on (name='123_log',filename='E:\123_log.ldf',size=2mb,filegrowth=1mb)';创建数据库的SQL语句，SQL Server2008中可以运行，但放到ADOQuery SQL中创建不了，大神能帮忙解答下吗

Answer 1

单引号中如果有单引号，需用两个单引号
ADOQuery1.SQL.Text:='CREATE DATABASE 123 on primary( name=''123_data'',filename=''E:\123_data.mdf'',size=5mb,maxsize=100mb,filegrowth=15%) log on (name=''123_log'',filename=''E:\123_log.ldf'',size=2mb,filegrowth=1mb)';