jung1975
asked on
generate insert statement with data dynamically
I have a table:A that has 50 rows...
Id code number
12 A 789
13 B 767
34 T 890
--- etc
I am trying to generate 50 insert statements with data in that table dynamically without typing 50 insert statement with data...
insert into test ( ID, code, number) values ( 12,'A', 787)
-- etc
How can i do this?
Id code number
12 A 789
13 B 767
34 T 890
--- etc
I am trying to generate 50 insert statements with data in that table dynamically without typing 50 insert statement with data...
insert into test ( ID, code, number) values ( 12,'A', 787)
-- etc
How can i do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.