11 2022 档案
摘要:选择指定tab: 1.ExcelRowIndex:为该行在源excel中的行索引 2.RowIndex:为读取数据时新集合中的行索引 ExcelRowIndex 和 RowIndex 并不相等 Reference: Kettle 连接 Oracle 使用手册 及 问题解决方案 Kettle 读取Ex
阅读全文
摘要:简单删除 DELETE TABLE_NAME WHERE KEY = 1; DELETE TABLE_NAME WHERE KEY IN (1, 2, 3); DELETE TABLE_NAME WHERE KEY IN (SELECT 1 FROM DUAL); 多条件删除 1.EXISTS DE
阅读全文
摘要:查询所有表对应的数据量 1.GROUP SELECT A.NAME AS 表名, MAX(B.ROWS) AS 记录条数 FROM SYS.SYSOBJECTS AS A INNER JOIN SYS.SYSINDEXES AS B ON A.ID = B.ID AND (A.XTYPE = 'U'
阅读全文
摘要:固定表头 <el-table-column label="姓名\N张三" header-align="center" // 设置列表表头居中 :render-header="renderHeader" > </el-table-column> 多语言表头对象 { table: { Name: '姓名
阅读全文
摘要:导入命名空间 using System.Data.SqlClient; 代码 var sqlBuilder = new StringBuilder("SELECT SUM(TOTAL) AS TOTAL FROM ("); sqlBuilder.Append(" SELECT COUNT(1) AS
阅读全文