摘要：DECLARE my_cursor CURSOR FOR select * from dbo.fun_kpi_mould_mjzfjsl_detail(:as_year,:as_parameter) using sqlzk;OPEN my_cursor ; fetch my_cursor into 阅读全文

摘要：DECLARE my_cursor CURSOR FOR execute P_L_WORKUNIT_SALARY_GSGS(:as_year,'1') ; OPEN my_cursor ; fetch my_cursor into :ls_items,:lc_m1,:lc_m2,:lc_m3,:lc 阅读全文

摘要：--1.创建一个package，包中定义两个方法，一个set值的方法，一个get值的方法create or replace package VIEW_GET_PRODUCT_YGS is --set值方法function set_writeday(writeday varchar2) return 阅读全文

摘要：--字符串根据特定字符分割成表数据create function [dbo].[f_split](@SourceSql varchar(8000),@StrSeprate varchar(10))returns @temp table(a varchar(100)) as begin declare 阅读全文