问:SQL脚本在DELPHI程序中怎样执行,在MS SQL中又怎样通过T-SQL语句调用? query1.sql.text:='SQL语句';query1.execSQL. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 想在系统安装是用SQL脚本初始化 query1.close; query1.sql.clear; query1.SQL.Add('Insert Into dclb values(:PointNo, :dcrq, :cd, :dcsj)'); query1.ParamByName('pointNo').asinteger := StoredProc1.fieldbyname('pointNo').asinteger; query1.ParamByName('dcrq').asDateTime := date; query1.ParamByName('cd').asinteger := StoredProc1.fieldbyname('cd').asinteger; query1.ParamByName('dcsj').asdatetime := sj; query1.ExecSQL;//或OPEN DataAccess页\Query --通过BDEADO页\ADOQuery --通过ADOprocedure TForm_login.Button1Click(Sender: TObject);begin with Query1 do begin Close; SQL.Clear; SQL.Add('select * from T_?? where'); try Open; except MessageDlg('Connect Failed',mtError, [mbOK], 0); Application.Terminate; end; end;end; 假如我用专门安装程序制作软件制作安装盘,怎么把SQL脚本打包进去,怎样才能执行SQL脚本 简单!1。用各类DB的命令行EXE执行2。用编程语言直接写个WIN32命令行的EXE QuickLeader,你可以把你说的写个例子吗? 1。在MSSQL的BINN目录下有个文件叫ISQL,exe,用法如下:usage: isql [-U login id] [-P password] [-S server] [-H hostname] [-E trusted connection] [-d use database name] [-l login timeout] [-t query timeout] [-h headers] [-s colseparator] [-w columnwidth] [-a packetsize] [-e echo input] [-x max text size] [-L list servers] [-c cmdend] [-q "cmdline query"] [-Q "cmdline query" and exit] [-n remove numbering] [-m errorlevel] [-r msgs to stderr] [-i inputfile] [-o outputfile] [-p print statistics] [-b On error batch abort] [-O use Old ISQL behavior disables the following] <EOF> batch processing Auto console width scaling Wide messages default errorlevel is -1 vs 1 [-? show syntax summary (this screen)]用-i参数带入你的外部文件如init.SQL即可 to wanwangzhiwang(万王之王)有'go'不行吧 儿子出生,散分~~ 青岛的程序设计工作者注意了 程序自已复制自已(高分送)急 奇怪奇怪好奇怪??????????? indy的发邮件的问题!见者有份! 用Activeform包装已存在的程序,在浏览器运行后点击应用程序出现错误 程序出错什么原因?急!! ''的问题 裸求高人修改生产管理系统 如何像Windows开始菜单一样,点击button弹出一个PopMenu呢? 请问怎样将求和得到的数据存入变量中?使用的是SQL! 请问哪里有关于Delphi的网站?
query1.sql.clear;
query1.SQL.Add('Insert Into dclb values(:PointNo, :dcrq, :cd, :dcsj)');
query1.ParamByName('pointNo').asinteger := StoredProc1.fieldbyname('pointNo').asinteger;
query1.ParamByName('dcrq').asDateTime := date;
query1.ParamByName('cd').asinteger := StoredProc1.fieldbyname('cd').asinteger;
query1.ParamByName('dcsj').asdatetime := sj;
query1.ExecSQL;//或OPEN
ADO页\ADOQuery --通过ADOprocedure TForm_login.Button1Click(Sender: TObject);
begin
with Query1 do begin
Close;
SQL.Clear;
SQL.Add('select * from T_?? where');
try
Open;
except
MessageDlg('Connect Failed',mtError, [mbOK], 0);
Application.Terminate;
end;
end;
end;
1。用各类DB的命令行EXE执行
2。用编程语言直接写个WIN32命令行的EXE
usage: isql [-U login id] [-P password]
[-S server] [-H hostname] [-E trusted connection]
[-d use database name] [-l login timeout] [-t query timeout]
[-h headers] [-s colseparator] [-w columnwidth]
[-a packetsize] [-e echo input] [-x max text size]
[-L list servers] [-c cmdend]
[-q "cmdline query"] [-Q "cmdline query" and exit]
[-n remove numbering] [-m errorlevel]
[-r msgs to stderr]
[-i inputfile] [-o outputfile]
[-p print statistics] [-b On error batch abort]
[-O use Old ISQL behavior disables the following]
<EOF> batch processing
Auto console width scaling
Wide messages
default errorlevel is -1 vs 1
[-? show syntax summary (this screen)]
用-i参数带入你的外部文件如init.SQL即可
有'go'不行吧