Click here to Skip to main content
12,951,619 members (56,913 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
Hi,

I have done with creation of dynamically created tables at runtime. But now I need to enter the data from these tables to other tables. When data comes into these tables just need to put into another tables. Please provide a suggestion, how I can accomplish my task.

Do I use cron jobs to fire triggers or storeprocedures but tables are dynamicall generated from data being sent to other tables that alreay existised?

Thanks,
Sahil
Posted 20-Jun-14 10:23am

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

there are ways to do that:
one of them could be using Trigger like the following

CREATE TRIGGER tbl1_after_insertT ON tbl1 AFTER insert as
BEGIN
 
    INSERT into tbl2(id, CODE, NAME)
        select id,CODE,NAME  FROM
        INSERTED
 
END


another one could be using replication, in your case if the tables are being created dynamically, it is very hard to set it up. but it's still an option
  Permalink  
Comments
SahilKataria 21-Jun-14 1:27am
   
thanks for your response, I already did that. But my tables are dynamically created with dynamic name everytime. So I want to do with taht way. Can you please suggest the way accordingly or provide some replication links or other way like do I use cron jobs?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,084
CHill60 3,480
Maciej Los 3,083
Jochen Arndt 1,975
ppolymorphe 1,830


Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 20 Jun 2014
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100