第1个回答 2011-03-18
declare @sql nvarchar(100)
declare @tableName nvarchar(100)
declare cur cursor for
select name from sysobjects where xtype='U' --搜索所有表名
open cur
while @@fetch_status=0
begin
set @sql='select * from [' + @tableName + '] ' --循环查询表数据
exec sp_executesql @sql
fetch next from cur into @tableName
end
close cur
deallocate cur
set nocount off
如果有高手 能一条Sql语句查出 请赐教!本回答被提问者采纳