Copying data from table to other table dynamically (with varying columns)

kiran240...

SOLVED CLOSED ACTIVE ANSWERED
User: kiran2401
Posted: on Apr 07, 2016 12:29 AM
Forum: Data Controls
Answer: 1
Views: 3196

Hi, 
   I have a problem here. 
I have a stored Procedure, which copies the data in one table to another table in other DB.

I have the query to copy the records to other table. 
But, tomorrow, new columns are added to the source table, then, how to dynamically copy the data from those columns to the destination column..

kindly suggest ..

Regards,
Kiran

Andrea

0 1

Reply
User: Andrea
Replied: on Apr 07, 2016 12:29 AM
Report

Hi @kiran2401, Please try the following Dynamically display data from other Table inside Repeater ItemTemplate on Button click in ASP.Net It might help you. Cheers Andrea.

kiran240...

0 2

Reply
User: kiran2401
Replied: on Apr 07, 2016 12:50 AM
Report

Hi.. I need  solution in Stored Procedure..

like: using information_schema.columns

 please help

Shashika...

0 3

Reply
ANSWER
User: Shashikant
Replied: on Apr 07, 2016 02:25 AM
Report

Hi,

You can simply recreate table.

Copying data from table to other table dynamically (with varying columns)

Company

Explore

Follow us

Contact Us