H
helpful sql
Hi all,
Are there any good Sql code generation tools out there in the market? If
not can you please give me tips or sample code for creating one?
I need to automate code generation for data integration. Here is what I
repeatedly need to do...
We have a table called CONTSUPP in our Sql Server database. All of our
clients have the same database structure so they all have the CONTSUPP
table. I need to create different kinds of views on this table for different
clients. I also need to generate Instead of Triggers on these views. Then I
need to write stored procedures to import data from another source table
into my views. The structure of the source table can vary by clients.
Thanks in advance...
Are there any good Sql code generation tools out there in the market? If
not can you please give me tips or sample code for creating one?
I need to automate code generation for data integration. Here is what I
repeatedly need to do...
We have a table called CONTSUPP in our Sql Server database. All of our
clients have the same database structure so they all have the CONTSUPP
table. I need to create different kinds of views on this table for different
clients. I also need to generate Instead of Triggers on these views. Then I
need to write stored procedures to import data from another source table
into my views. The structure of the source table can vary by clients.
Thanks in advance...