01 2014 档案

SQL代理执行EXE可执行程序
摘要：1.如果没有启用xp_cmdshell安全配置是不可以使用的--启用xp_cmdshellEXECsp_configure'xp_cmdshell',1GO--重新配置RECONFIGUREGO2.执行脚本xp_cmdshell{'command_string'}[,no_output]如：EXEC xp_cmdshell 'D:\RP\Job\Release\RegentsoftBIService.exe' 阅读全文
posted @ 2014-01-21 17:25 Rain520 阅读(1705) 评论(0) 推荐(0)
二表合并
摘要：二表数据合并到同一个表：select * from T1select * from T2select a.*,b.OutQty,c.InQty from ( select [DATE] from t1 union select [DATE] from t2) aleft join t1 b on a.[DATE] =b.[DATE] left join t2 c on a.[DATE] =c.[DATE] 阅读全文
posted @ 2014-01-16 14:09 Rain520 阅读(220) 评论(0) 推荐(0)
Oracle 分组聚合二种写法，listagg和wmsys.wm_concat
摘要：with temp as(select 'China' nation ,'Guangzhou' city from dual union allselect 'China' nation ,'Shanghai' city from dual union allselect 'China' nation ,'Beijing' city from dual union allselect 'USA' nation ,'New York' city from dual un 阅读全文
posted @ 2014-01-02 20:35 Rain520 阅读(9424) 评论(0) 推荐(0)