server导出csv文件不去除0 sql_高分！SQL 2000中不通过程序，怎么导出csv文件，或把数据倒进到csv中...

SQL codehttp://blog.csdn.net/picture_1230/archive/2008/02/25/2118217.aspx PL/SQL can do it, it might look like:

create or replace function dump_csv( p_query in varchar2,

p_separator in varchar2

default ', ',

p_dir in varchar2 ,

p_filename in varchar2 )

return number

AUTHID CURRENT_USER

is

l_output utl_file.file_type;

l_theCursor integer default dbms_sql.open_cursor;

l_columnValue varchar2(2000);

l_status integer;

l_colCnt number default 0;

l_separator varchar2(10) default ' ';

l_cnt number default 0;

begin

l_output := utl_file.fopen( p_dir, p_filename, 'w ' );

dbms_sql.parse( l_theCursor, p_query, dbms_sql.native );

for i in 1 .. 255 loop

begin

dbms_sql.define_column( l_theCursor, i,

l_columnValue, 2000 );

l_colCnt := i;

exception

when others then

if ( sqlcode = -1007 ) then exit;

else

raise;

end if;

end;

end loop;

dbms_sql.define_column( l_theCursor, 1, l_columnValue,

2000 );

l_status := dbms_sql.execute(l_theCursor);

loop

exit when ( dbms_sql.fetch_rows(l_theCursor) <= 0 );

l_separator := ' ';

for i in 1 .. l_colCnt loop

dbms_sql.column_value( l_theCursor, i,

l_columnValue );

utl_file.put( l_output, l_separator ||

l_columnValue );

l_separator := p_separator;

end loop;

utl_file.new_line( l_output );

l_cnt := l_cnt+1;

end loop;

dbms_sql.close_cursor(l_theCursor);

utl_file.fclose( l_output );

return l_cnt;

end dump_csv;

/

You would use that for example like this:

create or replace procedure test_dump_csv

as

l_rows number;

begin

l_rows := dump_csv( 'select *

from all_users

where rownum < 25 ',

', ', '/tmp ', 'test.dat ' );

end;

/

Make sure to read about the INIT.ORA parameters (utl_file_dir) you need to setup

!!!

------解决方案--------------------

楼上这个可是ORACLE了。

其实SQL2005比较简单了。

导出数据之后

1.选择数据源，选择要导出的表

2.选择目标，平面文件源----浏览-----文件类型(选CSV文件)，确定

3.下一步导出就可以了。

------解决方案--------------------探讨

楼上这个可是ORACLE了。

其实SQL2005比较简单了。