December 22, 2016 at 10:42 am
Hello,
I'm wondering if there's an SQL statement for inserting multiple rows of data in bulk.
Currently, I'm doing this:
INSERT INTO [dbo].[BowtieDMEquipmentLookup] ([EquipmentDescription]) VALUES ('Absorption Column')
INSERT INTO [dbo].[BowtieDMEquipmentLookup] ([EquipmentDescription]) VALUES ('Accumulator')
INSERT INTO [dbo].[BowtieDMEquipmentLookup] ([EquipmentDescription]) VALUES ('Adsorption Column')
INSERT INTO [dbo].[BowtieDMEquipmentLookup] ([EquipmentDescription]) VALUES ('Air Cooler')
INSERT INTO [dbo].[BowtieDMEquipmentLookup] ([EquipmentDescription]) VALUES ('Air Handling Unit')
INSERT INTO [dbo].[BowtieDMEquipmentLookup] ([EquipmentDescription]) VALUES ('Air Receiver')
.
.
.
It's just one column.
Is there something like this in the SQL language:
MULTI_INSERT INTO [dbo].[BowtieDMEquipmentLookup] ([EquipmentDescription]) MULTI_VALUES ('Absorption Column', 'Accumulator', 'Adsorption Column', 'Air Cooler', 'Air Handling Unit', 'Air Receiver')
I don't know how something like this would work for more than one column, but maybe there is something.
Thanks.
December 22, 2016 at 10:58 am
One option is you can do something like this:
INSERT INTO [dbo].[BowtieDMEquipmentLookup] ([EquipmentDescription])
VALUES
('Absorption Column'),
('Accumulator'),
('Adsorption Column'),
('Air Cooler'),
('Air Handling Unit'),
('Air Receiver')
Sue
December 22, 2016 at 6:17 pm
Cool, didn't know you could do that.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply