針對於已查詢出數據結果, 且在程式中執行Sql命令, 而非資料庫中的存儲過程 INSERT INTO TableName (Column1, Column2, Column3, Column4, Column5)SELECT Value1, Value2, Value3, Value4, Value ...
針對於已查詢出數據結果, 且在程式中執行Sql命令, 而非資料庫中的存儲過程
INSERT INTO TableName (Column1, Column2, Column3, Column4, Column5)
SELECT Value1, Value2, Value3, Value4, Value5
WHERE NOT EXISTS (SELECT PrimaryName FROM TableName WHERE PrimaryName = PrimaryValue)
