摘要：On Error Resume Nexttemp = 0 Set wshshell = wscript.CreateObject("wscript.shell")'啓動WMI服務(沒有這個服務就不行)wshshell.run("%comspec% /c regsvr32 /s scrrun.dll"),0,Truewshshell.run("%comspec% /c sc config winmg... 阅读全文

摘要：select * from importheaderdelete from importheader where sizes is null and model is nullselect * from importdetailselect * from calendarselect * from rma_detailselect * from rma_header--select * from ... 阅读全文

摘要：function get_emp_info return sys_refcursor; procedure get_emp_info(p_rc out sys_refcursor); procedure get_multiple_cursors(p_rc1 out sys_refcursor, p_rc2 out sys_refcursor, p_rc3 out sys_refcursor);en... 阅读全文

摘要：SQL 存取過程-- 找出要計算薪資的員工並找出他們的基本/月結資料select @sql='select a.id,a.empno,a.sex,a.workyeardate,a.enterdate,a.leavedate,isnull(cast(dbo.fgetemporgid(a.id,'''+@edate+''') as uniqueidentifier),a.workorgid) as w... 阅读全文