Bulk create customers using SQL Server data
Bulk creates customers by reading data from an external SQL Server database using the SOURCE clause. The column names in the source query must match the input columns of the Customers table (e.g. FirstName, LastName, Email).
INSERT INTO Customers(FirstName, LastName, Email, Phone)
SOURCE('MSSQL'
,'Data Source=localhost;Initial Catalog=tempdb;Integrated Security=true'
,'select ''John'' as FirstName, ''Doe'' as LastName, ''a.doe@gmail.com'' as Email, ''7705553111'' as Phone'
)