随笔分类 - ADO.NET
摘要:exec sp_executesql N'SELECT LA001, LA014, LA005, LA011, LA013, LA021 FROM cgjterp..INVLA INVLAWHERE LA001=@P1 AND LA009=@P2 ORDER BY LA001, LA009 ', N'@P1 varchar(20),@P2 varchar(10)', '301110101001', '01'这是执行动态sql的exec sp_executesql N'SELECT LA001, LA014, LA005,
阅读全文
摘要:View Code 1 using (SqlConnection conn = new SqlConnection(connStr)) 2 { 3 string sql = "[PRinserTcheck]";//存储过程名 4 using (SqlCommand cmd = new SqlCommand(sql, conn)) 5 { 6 //执行存储过程 7 ...
阅读全文

浙公网安备 33010602011771号