>Hi,
>
>In a stored procedure I have a hard coded Insert expression:
>
>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
>this expression based on variables. E.g.
>
>declare @FieldNames as varchar(max)
>set @FieldNames = 'col1, col2, col3'
>
>
>
>So, is it possible to create a variable for list of values and then combine it with the variable for the list of columns and
>execute the INSERT?
Not my subject but maybe buildup the string. Something like:
Declare @SQLQuery AS NVarchar(4000)
Set @SQLQuery = 'INSERT INTO mytable('+@FieldNames+') VALUES (@Val4Col1,@Val4Col2,@Val4Col3)
EXECUTE(@SQLQuery)