摘要:
http://www.abab123.com/index.html 阅读全文
摘要:
定义数据字符串*/declare @sourcesql varchar(100),@middlesql varchar(50)/*初始化字符串*/set @sourcesql = '4001,4002,4003,4004'/*循环提取以 ',' 分割都字符内容*/while(charindex(',',@sourcesql,1) > 0 )begin/*输出显示各个字符串的值*/select left(@sourcesql,charindex(',',@sourcesql,1) - 1)select @sourcesql = 阅读全文
该文被密码保护。 阅读全文
摘要:
public string RunProcedure(OleDbParameter[] paramInput, OleDbParameter[] paramOutput, string procName) { int cnt = 0; string returnString = "-2"; try { String ConnStr = OleDbHelper.GetOleDBConnection(); using (OleDbConnection connection = new OleDbConnection(ConnStr)) { OleDbCommand cmd = 阅读全文
该文被密码保护。 阅读全文
摘要:
#SYNC 10;SET SCHEMA TYCOON_SP;SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","TYCOON_DB2_1";CREATE PROCEDURE DB2INST1.SP_UPP_INDEX123(IN "IN_ID" INTEGER IN "IN_SCHOOL_ID" INTEGER, IN "IN_CREATE_DATE" DATE, OUT "ROWCOUNT" 阅读全文
摘要:
我弄了小半天才弄出来,希望对有需要的朋友有所帮助和提示。欢迎光临如转载请说明出处。DROP SPECIFIC PROCEDURE DB2INST1.SQL121129100123456;#SYNC 10;SET SCHEMA TYCOON_SP;SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","NORTHTYCOON";CREATE PROCEDURE DB2INST1.SP_UP_P_INV_WASTE(IN "IN_CREATE_WHEN" DA 阅读全文
摘要:
1.获取Return返回值SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ToString());conn.Open();SqlCommand MyCommand = new SqlCommand("SQL", conn);MyCommand.CommandType = CommandType.StoredProcedure;MyCommand.Parameters.Add(new SqlParameter(&q 阅读全文
该文被密码保护。 阅读全文