insert_Create

所属分类:Pascal/Delphi编程
开发工具:Delphi
文件大小:1597KB
下载次数:5
上传日期:2008-12-23 10:04:30
上 传 者mailmanb
说明:  该工具用Delphi7写的,可帮助我们生成一些插入语句。 例如: 现要向一台机(P2)的数据库(以HR为例)插入另一台机(P1)的HR_New_Info记录,可如下操作: 1.输入P1的IP,用户名,密码。数据库输入“HR” 2.在查询语句输入 select Title,Content,TypeName,Flag,DateAndTime from HR_New_Info 3.在插入语句输入 insert into HR_New_Info(Title,Content,TypeName,Flag,DateAndTime) 4.点击生成语句,可生成如下语句: insert into HR_New_Info(Title,Content,TypeName,Flag,DateAndTime) values( 政府招聘网上报名系统投入使用 , , 新闻资信 ,True, 2008-9-30 ) insert into HR_New_Info(Title,Content,TypeName,Flag,DateAndTime) values( 防洪防汛工作顺利完成 , , 新闻资信 ,True, 2008-9-15 ) 注,语句暂时只能保存为.sql文件
(Delphi7 written with the tool can help us generate some insert statement. For example: one is to drive (P2) of the database (to HR for example) into another machine (P1) of HR_New_Info records, may be as follows: 1. Enter the P1 s IP, user name, password. Database enter HR 2. In the query input select Title, Content, TypeName, Flag, DateAndTime from HR_New_Info3. In the insert statement enter insert into HR_New_Info (Title, Content, TypeName, Flag, DateAndTime) 4. Clicks generated statement can be generated the following statement: insert into HR_New_Info (Title, Content, TypeName, Flag, DateAndTime) values (the Government for recruiting online registration system put into use, the press information, True, 2008-9-30) insert into HR_New_Info (Title, Content, TypeName, Flag , DateAndTime) values (the successful completion of flood prevention work in flood prevention, credit information, True, 2008-9-15) note, the statement can only be preserved for the time being. sql file)

文件列表:
插入语句生成器\InsertStr.cfg (434, 2008-08-22)
插入语句生成器\InsertStr.dof (3103, 2008-08-22)
插入语句生成器\InsertStr.dpr (187, 2008-08-22)
插入语句生成器\InsertStr.exe (825344, 2008-08-22)
插入语句生成器\InsertStr.res (162184, 2008-08-22)
插入语句生成器\Main.dcu (7894, 2008-08-22)
插入语句生成器\Main.ddp (51, 2008-08-22)
插入语句生成器\Main.dfm (2927, 2008-08-22)
插入语句生成器\Main.pas (3163, 2008-08-22)
插入语句生成器\qtintf70.dll (4082688, 2002-08-20)
插入语句生成器 (0, 2008-08-22)

近期下载者

相关文件


收藏者