如何调用SqlServer200导出数据到Excel的存储过程?

[cfqmxh]

我的存储过程是:
CREATE proc dbo.export(@dbname nvarchar(1000))
as
declare @s varchar(8000)
set @s='bcp '+@dbname+' out c:\ls.xls -c -q -S"(cfq)" -U"" -P""'
exec master..xp_cmdshell @s
GO
然后在SQL查询分析器中我该怎样调用这个存储过程呢?谢谢!

[zjcxc]

--调用
exec dbo.export 'pubs.dbo.jobs'

[cfqmxh]

如果我要代入的参数是一SQL语句那我该咋办?
是:exec dbo.export 'Select * from jobs'吗?
是不是存储过程中的out要改成queryout?
不过我这样改了也不行!出如下错:
复制方向必须是 'in'、'out' 或 'format'。
用法: 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"]
NULL

[zjcxc]

--那就要改存储过程
CREATE proc dbo.export(@dbname nvarchar(1000))
as
declare @s varchar(8000)
set @s='bcp '+@dbname+' queryout c:\ls.xls -c -q -S"(cfq)" -U"" -P""'
exec master..xp_cmdshell @s
GO

[rivey]

exec dbo.export 'Select * from dbname.dbo.job'

[officecn]

直接执行就行了，存储过程可以当做普通的SQL来执行。

[cfqmxh]

我改了存储过程了然后用:
exec dbo.export 'Select * from aa.dbo.Field'
怎么老是报下面的错:
复制方向必须是 'in'、'out' 或 'format'。
用法: 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"]
NULL

[zjcxc]

--少写了"
CREATE proc dbo.export(@dbname nvarchar(1000))
as
declare @s varchar(8000)
set @s='bcp "'+@dbname+'" queryout c:\ls.xls -c -q -S"(cfq)" -U"" -P""'
exec master..xp_cmdshell @s
GO

[cfqmxh]

问题解决!
非常感谢!
结贴!