Subject | Insert by select question |
---|---|
Author | Joe Martinez |
Post date | 2003-05-26T18:55:51Z |
Let's say I have two tables: Table1 and Table2, with the exact same structure.
I can do:
insert into table 1 select * from table2 where ...
What happens if the tables have a computed field? Will this bomb out
because you can't set the values of computed columns? Or, is FB smart
enough to skip the computed columns?
-Joe
I can do:
insert into table 1 select * from table2 where ...
What happens if the tables have a computed field? Will this bomb out
because you can't set the values of computed columns? Or, is FB smart
enough to skip the computed columns?
-Joe