Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Bulk inserts using SQL in Ensemble

Question
Jimmy Christian · Jun 16, 2021

Bulk inserts using SQL in Ensemble

Hello Community,

I am trying to insert multiple values in a table. Below is the simple sql statement.

Insert Into TableX

values ('Name', 'Address', 'Phone')

How can i do multiple inserts(rows) in one single statement?

Values are not in another table, so i cannot use Select into.

Thanks,

Jimmy Christian.

#SQL #Ensemble

Source URL:https://community.intersystems.com/post/bulk-inserts-using-sql-ensemble