随笔分类 -  数据库

摘要：//查询以井结束的记录SELECT f_wellnumber, SUBSTRING(f_wellnumber, 1, LEN(f_wellnumber) - 1) AS Expr1FROM CY_wellrecordWHERE (f_wellnumber LIKE '%井') //替换井字UPDATE CY_wellrecordSET f_wellnumber = SUBSTRING(... 阅读全文

摘要：在sql server中，IIF(SCTS>=1,YCYL/SCTS,0) 的替代写法CASE WHEN SCTS >= 1 THEN YCYL / SCTS ELSE 0 END 阅读全文

摘要：string a="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\data.mdb;Persist Security Info=False;"; OleDbConnection cn=new OleDbConnection(a); // OleCommand cm=new OleDbCommand("select * from pet... 阅读全文