摘要： //循环查询的结果 foreach (DataRow row in oDataTableGuidePrice.Rows) { //将结果按,风格成数组 IList<string> olist = row["A"].ToString().ToUpper().Split(',').ToList<string>(); flag = true; //判断是否有重复值 foreach (string str1 in args) if (!olist.Contains(str1.ToUpper())) { flag = false; break; 阅读全文

摘要： 阅读全文

摘要： 一.定义表变量DECLARE @T1 table(UserID int , UserName nvarchar(50),CityName nvarchar(50));insert into @T1 (UserID,UserName,CityName) values (1,'a','上海')insert into @T1 (UserID,UserName,CityName) values (2,'b','北京')insert into @T1 (UserID,UserName,CityName) values (3,'c&# 阅读全文