VB的数据环境,添加链接之后,再添加一个Command,就可以用SQL生成器来生成一个SQL．ACCESS在做ADP设计查询时，也可以调用SQL生成器。在SQL2000的企业管理器中，里面也有一个SQL生成器。我发现它们的外观都相同，很可能是引用某个部件处理的。
现在本人编写的程序中，也需调用SQL生成器，如何调用？请高手们旨教。谢谢。
现在本人编写的程序中，也需调用SQL生成器，如何调用？请高手们旨教。谢谢。
既然有现成的可以调用,为什么还要自己来写一个生成器?而且SQL生成器很难写的呀.
VisData 示例，在VB专业版和企业版中，其源代码可以在 Samples\VisData 目录中找到
没有用,这个东西没有调用SQL生成器.我需要的是直接调用SQL生成器.
不知楼说所说的SQL生成器是需要生成脚本还是分析SQL语法？
说的不是很明确
哪种数据库？不同的数据库SQL语法是不一样的呀。如果是建库的，SQL-DMO的DataBase对象的Script方法可以生成重建当前数据库的T-SQL命令
有吗？我还真不知道！在哪里？怎么用？
我只知道，可以生成建库的脚本~
这就是SQL生成器了.其实是一个图形化设计SQL指令的窗体.很常用呀..
汗，没注意，一般都是手工输入SQL的~
不是很明白你的意思,能不能详细一点呢?
它们在引用中的名称是:Microsoft SQL XXX 8.0 ,都在MICROSOFT SQL的安装目录里面,所以小弟认定,这个SQL生成器就一定在这几个DLL中!!各位大虾,请问一下,在哪里可以找到这几个DLL的使用说明??
1、VB这样的操作肯定在调用某些DLL，只是这些dll我们不常用所以不知
2、如果你知道需要那些dll或者不知道，你都应该去找KB
The programs in the replctrl folder are samples of how to include the SQL Merge and SQL Distribution controls in a custom application. This sample is located in C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Samples\sqlrepl\replctrl.To run the sample programs On the computer that will be a Publisher with a local Distributor, verify that the SQL Server Agent is running. If it is not running, start it.
Open SQL Query Analyzer, open \Samples\sqlrepl\replctrl\instsamp.sql, and then run instsamp.sql. This SQL script configures the computer for publishing and distribution, enables the computer as a Subscriber, adds a distribution database with the name distributor, creates a transactional publication named SampleTransactionalPublication, and creates a merge publication named SampleMergePublication.
The instsamp.sql script creates pull and push subscriptions for each publication and creates and configures a database called Northwind_replica as the subscription database. Any warnings from the script regarding tables that have been created with a maximum row size that exceeds the maximum number of bytes per row can be ignored. The computer is now configured as a Publisher with a local Distributor and enabled as a Subscriber.
The Northwind publication database will have two publications: SampleTransactionalPublication and SampleMergePublication. The instance of SQL Server contains a new subscription database, Northwind_replica.After the instsamp.sql script has completed successfully, in SQL Server Enterprise Manager, expand Replication Monitor, expand the Agents folder, and then click the Snapshot Agents folder. In the right pane, for each agent listed, right-click, and then click Start Agent. This starts the Snapshot Agents for each publication and creates a snapshot for each publication.
Start Visual Basic, and then open \Samples\sqlrepl\replctrl\VB\replsamp.vbp.
On the Project menu, click References, and then in the Available References list, verify that the following controls are selected:
Microsoft SQL Distribution Control 8.0
Microsoft SQL Merge Control 8.0
Microsoft SQL Snapshot Control 8.0
Microsoft SQL Replication Errors 8.0
On the File menu, click Make ReplSamp.exe, and then save the executable to a directory.
Run replsamp.exe. The following options will be displayed:
Generate Snapshot for Transactional PublicationCreates a snapshot for the Northwind transactional publication. The snapshot activity can be monitored interactively in SQL Server Enterprise Manager using Replication Monitor and the Agents folder.Generate Snapshot for Merge PublicationCreates a snapshot for the Northwind merge publication. The snapshot activity can be monitored interactively in SQL Server Enterprise Manager using Replication Monitor and the Agents folder.Update Transactional Subscription TablesRuns the Distribution Agent and applies the snapshot and schema at the subscription database, Northwind_replica. After the SQL Replication Sample dialog box shows that the task has completed, the Northwind_replica subscription database shows the new tables. The distribution activity can be monitored interactively in SQL Server Enterprise Manager using Replication Monitor and the Agents folder.Update Merge Subscription TablesRuns the Merge Agent and applies the snapshot data and schema at the merge subscription database, Northwind_replica. After the SQL Replication Sample dialog box shows that the task has completed, the Northwind_replica subscription database shows the new tables. The merge activity can be monitored interactively in SQL Server Enterprise Manager using Replication Monitor and the Agents folder.
qq群8622612，再多的问题进去问好了，里面有INTEL的家伙
CREATE VIEW dbo.VIEWqtgkhf
AS
SELECT dbo.zlqtgk.QiTaGuKeID AS gkid, dbo.zlqtgk.XingMing AS gkxm,
dbo.zlqtgk.XingBie AS gkxb, dbo.zlqtgk.ZhuZhaiDianHua AS gkzzdh,
dbo.zlqtgk.ShouJi AS gksj, dbo.zlqtgk.ZiXunCiShu AS gkzxcs,
dbo.zlqtgk.ShouCiZiXunRiQi AS gksczxrq, dbo.zlqtgk.HuiFangCiShu AS gkhfcs,
dbo.zlqtgk.XingQuJiBie AS gkxqjb, dbo.zlgkzt.GuKeZhuangTai AS gkzt,
dbo.VIEWgkhf.HuiFangRiQi AS gkhfrq
FROM dbo.zlqtgk INNER JOIN
dbo.zlgkzt ON
dbo.zlqtgk.GuKeZhuangTaiID = dbo.zlgkzt.GuKeZhuangTaiID LEFT OUTER JOIN
dbo.VIEWgkhf ON dbo.zlqtgk.QiTaGuKeID = dbo.VIEWgkhf.QiTaGuKeID
WHERE (dbo.zlgkzt.GuKeZhuangTai = '其他顾客')
在VB中调用Dim adocon As ADODB.Connection
Dim adoRec As ADODB.Recordset
.
.
.
.
.
.strSQL = "select * from VIEWqtgkhf" & strWhereString
adoRec.Open strSQL, adocon, adOpenDynamic, adLockPessimistic
SQL语句生成器 V2.0