1。列出所有的用户表
select * from sysobjects where objectproperty(id, 'isusertable')=1
2。列出所有用户表的第一条记录
exec sp_msforeachtable 'select top 1 * from ?'
select * from sysobjects where objectproperty(id, 'isusertable')=1
2。列出所有用户表的第一条记录
exec sp_msforeachtable 'select top 1 * from ?'