how to give input dynamically to a insert statement in sqlserver
Declare @sql_tmp varchar(100) set @sql_tmp="insert into table1(col1,col2..) select 'val1','val2','') " sp_executesql @sql_tmp