Question

sql 查询出来的数据数据导入excel中 出现问题 在线等

EXEC master..xp_cmdshell 'bcp "SELECT * FROM ty" queryout "e:\Temp3.xls" -c -q -S"WIN-H881NOMIV44" -U"hk" -P"1212"'

SQLState = S0002, NativeError = 208
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]对象名 'ty' 无效。
SQLState = 37000, NativeError = 8180
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。
NULL

不想要网上复制过来的 要的是你的解决

Answer 1

右击查询结果-另存为-EXCEL格式或者复制粘贴到EXCEL中.复制粘贴的会比较好点,会跟据每列来分列,另存为的话就全部在一列了.

Answer 2

CREATE OR REPLACE PROCEDURE "TEST"."PROC_INSMONTH_JL" AS
STRDATE1 VARCHAR2(50);
stryear VARCHAR2(10);
MYSTR VARCHAR2(2000);
BEGIN
STRDATE1:=TO_CHAR(SYSDATE,'YYYY-MM-DD');
stryear:=TO_CHAR(SYSDATE,'YYYYMM');
MYSTR:='INSERT INTO Report_Month_JL'||stryear||
' SELECT SID,PID,sum(newvalue) as Rvalue,sum(newvalue) as Newvalue,||STRDATE1|| as Ddate'||
' FROM REPORT_JL'||stryear||
' WHERE (PTIME BETWEEN SYSDATE-1 and SYSDATE)'||
' GROUP BY SID,PID';
EXECUTE IMMEyDIATE MYSTR;
COMMIT;
---EXCEPTION
--- WHEN OTHERS THEN
---NULL;
END;

Answer 3

这个在网上可以搜到完整的代码的！你可以查找一下！