Insert INTO 目标表(id,供应商名称,供应商地址) Select DISTINCTROW * FROM (Select 1 AS ID,"天鸣1" AS 供应商名称,"广东中山" AS 供应商地址 FROM MSysObjects UNION Select 2 AS ID,"天鸣2" AS 供应商名称,"广东中山" AS 供应商地址 FROM MSysObjects UNION Select 3 AS ID,"天鸣3" AS 供应商名称,"广东中山" AS 供应商地址 FROM MSysObjects UNION Select 4 AS ID,"天鸣4" AS 供应商名称,"广东中山" AS 供应商地址 FROM MSysObjects) AS tblTemp;
Note: But the Row will be mutil when the inserting row only one. The repeat number will be reflect by the table MSysObjects.
Anybody know it's why?