摘要:
CREATE PROCEDURE PROC_FenYe@tableName varchar(50);@pageSize int;@currentPage intASSELECT TOP @pageSize * FROM @tableNameWHERECR_Id NOT IN(SELECT TOP (... 阅读全文
摘要:
创建一个只有输入参数的存储过程create procedure proc_user@name varchar(20),@Password varchar(100)asselect * from loginuserwhere name like @name---创建一个有输入和输出参数的存储过程cre... 阅读全文
摘要:
1,传入参数,传出参数public int GetTeam1Id(string userId) { int team1ID = -1; string strSPName = "PDM.PRODNAME_PHONEINFO_PKG.GET_TEAM1_ID"; using (OracleConnect... 阅读全文