开发者

how do i generate SQL script at runtime in VB6.0

开发者 https://www.devze.com 2023-02-13 22:19 出处：网络

how do i Generate SQL Script at ru开发者_如何学Pythonntime from VB6.0 and DB as SQL Server, generate all tables,views,PK,FK.Stored Procedures,Triggers from existing database. thanks in advance.The sim

相关专题：

how do i Generate SQL Script at ru开发者_如何学Pythonntime from VB6.0 and DB as SQL Server, generate all tables,views,PK,FK.Stored Procedures,Triggers from existing database. thanks in advance.

The simplest way I found to do this sort of thing was to use the SQL Distributed Object Model that you get with SQL Server and it works great with VB6. The last time I tried it was with SQL Server 2000 but the theory should still be good.

Give this link a try as a good start and take it from there, this shows you how to get at the stored procedures http://support.microsoft.com/kb/315505

Once you have got this bit down the other bits you need should be simple enough.

I hope this helps.

Cheers