SELECT CASE WHEN column_id = MIN(column_id) OVER(PARTITION BY 1) THEN 'INSERT INTO ' + OBJECT_NAME(object_id) + ' (' ELSE '' END + name + CASE WHEN column_id = MAX(column_id) OVER(PARTITION BY 1) THEN ')' ELSE ', ' END FROM sys.columns WHERE object_id = OBJECT_ID('TableName') ORDER BY column_id