sybase动态执行导出语句

 

begindeclare @sql varchar(200);select 1;--必须加上这句话，不然会报错 试试看呢 set temporary option temp_extract_column_delimiter='|';set @sql = 'set temporary option temp_extract_name1= ''/opt/iq/ccl/测试.txt''';execute(@sql);set @sql = 'select * from tbFengXiCaiYing_YH;';execute(@sql);set temporary option Temp_Extract_Name1 = ''; commit; end