C# SQL占位符
string connString = ConfigurationManager.AppSettings["SqlConn"].ToString(); var conn=new SqlConnection(connString); //var cmd = new SqlCommand("SELECT alliance,ballid FROM talliance with(nolock) WHERE type=8 AND alliance like '%'+@alliance;"); var cmd = new SqlCommand("SELECT alliance,ballid FROM talliance WHERE type=8 AND alliance like ''+ @alliance +'%';"); cmd.Parameters.Add(new SqlParameter("@alliance", SqlDbType.NVarChar, 1000)); //cmd.Parameters[0].Value = "||ATP Sydney international match"; cmd.Parameters[0].Value = "ATP 悉尼國際賽||"; cmd.Connection = conn; conn.Open(); var dr = cmd.ExecuteReader(); while (dr.Read()) { Console.WriteLine("alliance:"+dr[0].ToString() +"---"+"ballid:"+dr[1].ToString()); } dr.Dispose(); conn.Close(); Console.ReadKey();
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步