哪位高手帮忙一下，用存储过程怎么从一个表的一个text 字段里批量导出文件

[北极羊]

哪位高手帮忙一下，用存储过程怎么从一个表的一个text 字段里批量导出文件
比如有一个表　table1(id int ,content text,createdate)
将每一条记录中的content字段导出到文件里，文件名以createdate 中的年月日命名，还有oracle数据库的

[huailairen]

create proc 导出
as
begin
exec('xp_cmdshell bcp命令')
end

[北极羊]

谢谢指教！我试试

[北极羊]

我还是不知道怎么写在cmd怎么生成文件，能说的具体点吗？

[junshi_liu]

用法: bcp {dbtable | query} {in | out | queryout | format} datafile
[-m maxerrors] [-f formatfile] [-e errfile]
[-F firstrow] [-L lastrow] [-b batchsize]
[-n native type] [-c character type] [-w wide character type]
[-N keep non-text native] [-V file format version] [-q quoted identifier]
[-C code page specifier] [-t field terminator] [-r row terminator]
[-i inputfile] [-o outfile] [-a packetsize]
[-S server name] [-U username] [-P password]
[-T trusted connection] [-v version] [-R regional enable]
[-k keep null values] [-E keep identity values]
[-h "load hints"]