Kenluo

摘要： 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... 阅读全文