On an existing table, I want to add 47 columns using
alter table script
select Distinct FieldName From customFields
Above query will list 47 rows and these row names I need to create in another table (table name is Equipment) as Column.
I am using MS SQL 2017. Please help.