qq_32002821的博客

1、查询某表中某列不重复值 SELECT DISTINCT c.ChargeKindID,k.`Name` from carinoutrec c LEFT JOIN chargekind k on c.ChargeKindID=k.ID 2.查询某个字段包含字符串 SELECT * from carinoutrec WHERE Memo LIKE '%无入场记录%'; 3.记录不存在插入...

   SqlConnection MyConnection = new SqlConnection(ComS.connectionString);                        MyConnection.Open();                        SqlCommand command = new SqlCommand();                     ...