insert into mytable (col1, col2, col3) values (@Val4Col1, @Val4Col2, @Val4Col3)Since the list of columns and values has to be built dynamically, I need to be able to create
declare @FieldNames as varchar(max) set @FieldNames = 'col1, col2, col3' -- and I can't even figure how to concatinate the list of values into a variableSo, is it possible to create a variable for list of values and then combine it with the variable for the list of columns and