Insert a an array into an SQL table

Question

I have code to get installed applications off the computer and want to add it into an SQL table. how do I do this and keep formatting ?

I would like it to be app1 newline app2 newline app3

ArrayOfApps = GetApps();

USE ComputerData INSERT INTO InstalledApps ( Apps ) VALUES (ArrayOfApps);"

Don't do this. Insert into separate rows and format only for presentation. — Alejandro
– Alejandro, Commented Jul 22, 2021 at 12:17
How do you suggest? My table is something like "computername, osname, installedapps" do you suggest multiple tables or something? — Pavle Stojanovic
– Pavle Stojanovic, Commented Jul 22, 2021 at 12:35
Hold only one piece of data per row/column. Probably the best is to remove "installedapps" and add a second table with (idoffirsttable, installedapp) which contains one row per program. Second best alternative would be inserting multiple rows, with the same name/os and different program. In any case, the formating is delegated to the visual layer. — Alejandro
– Alejandro, Commented Jul 22, 2021 at 12:42

Amit Verma · Accepted Answer · 2021-07-22 12:11:19Z

1

Prepare your query like this

USE ComputerData 
INSERT INTO InstalledApps ( Apps ) VALUES (ArrayOfApps[0]),(ArrayOfApps[1]),(ArrayOfApps[2]);"

answered Jul 22, 2021 at 12:11

Amit Verma

2,4882 gold badges12 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

If I was to display this afterwards would it appear like this : app1app2app3 or app1, app2, app3