生成数据库所有表的查询语句

select 'select * from dbo.' + [name] from dbo.sysobjects where xtype = 'U' order by [name]
原文地址:https://www.cnblogs.com/strugglepcx/p/1781089.html