摘要:
use ceshi01 --库名 SELECT表名 = Case When A.colorder=1 Then D.name Else '' End,表说明 = Case When A.colorder=1 Then isnull(F.value,'') Else '' End,字段序号 = A.c 阅读全文
摘要:
layui,table,弹框 阅读全文
摘要:
//得到List<HashTable>里面的listUnFix然后取listUnFix判断tempfix里面得值 List<Hashtable> list = new List<Hashtable>(); for (int i = 1; i <= 3; i++) { List<Hashtable> 阅读全文
摘要:
分割字符到列DECLARE @a VARCHAR(10)SET @a ='00G-2-1102'SELECT CHARINDEX('-',@a,CHARINDEX('-',@a))SELECT CHARINDEX('-',@a,CHARINDEX('-',@a)+1) SELECT SUBSTRIN 阅读全文
摘要:
string ruhufugailv = "0"; string formulaSet = "A/(A+B+C)*100"; string formulaSet01 = formulaSet; formulaSet01 = formulaSet01.Replace("A", "" + (decima 阅读全文
摘要:
////在出现未处理的错误时运行的代码 //Response.Clear(); //Response.StatusCode = 404; //Response.Write("<!DOCTYPE html>"); //Response.Write("<html>"); //Response.Write 阅读全文
摘要:
sqlserver数据库字段bit等于bool类型 ,false等于0,true等于1 阅读全文
摘要:
1.layui.config({ base: '../layuiadmin/' //静态资源所在路径 }).extend({ index: 'lib/index' //主入口模块 }).use(['index', 'gas_group_customer', 'table', 'gas_common' 阅读全文
摘要:
修改客户表 编号为 0101007002,0101007003的楼栋号 007-1-102,007-1-201 UPDATE gas_customerSET building= CASEWHEN govid=380 and customer_no='0101007002' THEN '007-1-1 阅读全文