有个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