If you use an INSERT INTO <table1> SELECT * FROM <other table2 with
same fields>, what is the behavior for the following situations:
- Some (but not all) of the selected records in <table2> have
duplicates in <table1>? Does the entire statement fail or only for
rows with duplicates in <table1>?
- Can I still do this statement if the indexes and column
*constraints* are different in <table2>? The columns themselves have
the same size and datatypes but there would likely be additional
indexes but fewer constraints on <table2>
- Can the MERGE statement be used with a query to update multiple
rows and would this eliminate the issues above?
Received on Thu Jan 29 2004 - 10:28:41 CST
