DECLARE @table SYSNAME
SELECT @table = 'dbo.t仓库' /* 表名 */
DECLARE @insert_sql VARCHAR(MAX)
SELECT @insert_sql =
CASE
WHEN @insert_sql IS NULL
THEN '''INSERT INTO ' + @table + ' SELECT ''+'
ELSE @insert_sql + '+'', ''+'
END
+ 'isnull(sys.fn_sqlvarbasetostr(' + name + '), ''NULL'')'
FROM sys.columns
WHERE object_id=OBJECT_ID(@table)
EXEC('SELECT ' + @insert_sql + 'as ins FROM ' + @table)