January 18, 2012 at 12:27 am
hi
one database i have one table is there.
in that table 200 rows are there
so my question is
1to 100 the rows data will be store in one table and the
101 to 200 rows data to store in another table..
how to do?
if any updates changes happen in the source table , will be reflect on the tables also..how to do ( means i have to split the source table data into two tables)
plz let me know
January 18, 2012 at 1:42 am
anilr71 (1/18/2012)
hione database i have one table is there.
in that table 200 rows are there
so my question is
1to 100 the rows data will be store in one table and the
101 to 200 rows data to store in another table..
What criteria will decide whether the rows are going to Table1 or Table2? Ordinal position? Based on which column?
if any updates changes happen in the source table , will be reflect on the tables also..how to do ( means i have to split the source table data into two tables)
plz let me know
A trigger on the original table would do the trick.
-- Gianluca Sartori
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply