create table GRDA(sfzh varchar(10))
insert GRDA
select 'aaaa'
union all select 'aaaa'
union all select 'bbxx'
union all select 'aabbvaa'
union all select 'xx'
union all select 'xx'
union all select 'aaaa'---例子
EXEC master..xp_cmdshell 'bcp "select convert(char(10),getdate(),21) union all select * from GRDA" queryout c:\DT.txt -c -Syxz -Usa -Pleo'
insert GRDA
select 'aaaa'
union all select 'aaaa'
union all select 'bbxx'
union all select 'aabbvaa'
union all select 'xx'
union all select 'xx'
union all select 'aaaa'---例子
EXEC master..xp_cmdshell 'bcp "select convert(char(10),getdate(),21) union all select * from GRDA" queryout c:\DT.txt -c -Syxz -Usa -Pleo'
insert GRDA
select 'aaaa'
union all select 'aaaa'
union all select 'bbxx'
union all select 'aabbvaa'
union all select 'xx'
union all select 'xx'
union all select 'aaaa'---例子
EXEC master..xp_cmdshell
'bcp "select convert(char(10),getdate(),21) union all select * from GRDA" queryout c:\DT.txt -c -S你的服务器名或IP -Usa -P密码'
---select convert(char(10),getdate(),21) union all select * from GRDA 这句换成你的语句就可以了
---c:\DT.txt 这个是路径和文件名
万分感谢!