随笔分类 - DataBase

要将一个数据库的所有表格使用批通信程序取出（BCP OUT），有何较快的方法？

摘要：select 'bcp pubs..'+name+' out'+' d:\test\'+name+'.txt -c -Stechnology1 -Usa -P' from sysobjects where type = 'U' 阅读全文

posted @ 2005-11-06 01:13 轻舞flash 阅读(471) 评论(0) 推荐(0)

null

摘要：FETCH NEXT FROM @tables_cursor INTO @tablename 15WHILE (@@fetch_status -1) 16BEGIN 17EXEC ('Select ' + @quote+'Rows in ' + @tablename + ' = '+ @quote + ', count(*) from '+ @tablename) 18FETCH NEXT FROM @tables_cursor INTO @tablename 19END 阅读全文

posted @ 2005-11-06 01:08 轻舞flash 阅读(202) 评论(1) 推荐(0)