有个SQL2000数据库，n多个表，也n多条数据，我想每个表导100条数据出来

每个表生成一个tmp_表名，新表，插入100条数据进去

use 库名

DECLARE @tbname varchar(100)
DECLARE @sql varchar(200)

DECLARE table_cur CURSOR FOR
SELECT name FROM sysobjects WHERE type='u'

OPEN table_cur
FETCH NEXT FROM table_cur INTO @tbname

WHILE @@fetch_status = 0
BEGIN

if(substring(@tbname,1,3) = 'tmp')
begin
FETCH NEXT FROM table_cur INTO @tbname
continue
end

SELECT @sql = 'select top 100 * into tmp_'+@tbname+' from '+@tbname
exec (@sql)

FETCH NEXT FROM table_cur INTO @tbname
END
DEALLOCATE table_cur