SELECT NAME FROM SYSOBJECTS WHERE XTYPE='U' AND NAME LIKE 'SS%'要导出?
---导出到哪里去? select name from sysobjects where xtype='u' and name like 'ss%'
EXEC sp_MsForeachTable @command1=N' DECLARE @cmd nvarchar(4000); SET @cmd = N''bcp MyTest.? out G:\?.txt -c -T''; EXEC xp_cmdshell @cmd; ', @whereand=N' and o.name like ''ss%''';
把所有的数据都导出到一个txt文档中。Declare @iSQL nvarchar(600) declare @tbname varchar(100) Declare iCursor Cursor For select name from sys.objects where type='U' and name like 'SS%' Open iCursor Fetch Next from iCursor Into @tbname While @@Fetch_Status = 0 Begin Set @iSQL='bcp "DBName.dbo.'+@tbname+'" out "D:\file.TXT" -c -S"192.168.0.1" -U"sa" -P"pwd"' EXEC master..xp_cmdshell @iSQL Fetch Next from iCursor into @tbname End Close iCursor Deallocate iCursor
SELECT NAME FROM SYSOBJECTS WHERE XTYPE='U' AND NAME LIKE 'SS%'
select name from sysobjects where xtype='u' and name like 'ss%'
@command1=N'
DECLARE @cmd nvarchar(4000);
SET @cmd = N''bcp MyTest.? out G:\?.txt -c -T'';
EXEC xp_cmdshell @cmd;
',
@whereand=N' and o.name like ''ss%''';
declare @tbname varchar(100)
Declare iCursor Cursor For
select name from sys.objects where type='U' and name like 'SS%'
Open iCursor
Fetch Next from iCursor Into @tbname
While @@Fetch_Status = 0
Begin
Set @iSQL='bcp "DBName.dbo.'+@tbname+'" out "D:\file.TXT" -c -S"192.168.0.1" -U"sa" -P"pwd"'
EXEC master..xp_cmdshell @iSQL
Fetch Next from iCursor into @tbname
End
Close iCursor
Deallocate iCursor