SQL把查询结果保存到TXT文件?

[ling_long]

SQL想把查询结果保存到TXT文件,下面是我的执行语句,运行的结果是"第 1 行: 'Y2009M03D07H' 附近有语法错误".
exec Bam.dbo.tbl_Log 'bcp "select * from [dbo].[tbl_Log] where sOpTime>'Y2009M03D07H' and sOpTime<'Y2009M03D14H'"out "c:\shlr0307AND14" -c -T'

[csdyyr]

exec Bam.dbo.tbl_Log 'bcp "select * from [dbo].[tbl_Log] where sOpTime>''Y2009M03D07H'' and sOpTime <''Y2009M03D14H''"out "c:\shlr0307AND14" -c -T'

[playwarcraft]

sql 字串中的单引号，要用2个单引号来表示
exec Bam.dbo.tbl_Log 'bcp "select * from [dbo].[tbl_Log] where sOpTime>''Y2009M03D07H'' and sOpTime <''Y2009M03D14H''"out "c:\shlr0307AND14" -c -T'

[dawugui]

EXEC master..xp_cmdshell 'bcp "Select * from [dbo].[tbl_Log] where sOpTime>'Y2009M03D07H' and sOpTime <'Y2009M03D14H'" queryout c:\shlr0307AND14 -c -Sservername -Usa -Ppassword' 

[ling_long]

运行exec Bam.dbo.tbl_Log 'bcp "select * from [dbo].[tbl_Log] where sOpTime>''Y2009M03D07H'' and sOpTime<''Y2009M03D14H''"out "c:\shlr0307AND14" -c -T'
结果是"过程 'tbl_Log' 的请求失败，因为 'tbl_Log' 是 表 对象"。