
sql查询
爱是向我的
java开发
展开
-
sql查询where/in
public List<Object> getHousePeopleNoById(String roomObjectId,TableHistory table) { StringBuilder selectSql = new StringBuilder(); String tablename=table.getTableName().trim() + "_BEFORE原创 2016-07-29 14:09:48 · 1598 阅读 · 0 评论 -
查询中文/英文询盘id集合
/** * 查询中文/英文询盘id集合 */原创 2016-11-14 09:52:28 · 507 阅读 · 0 评论 -
内部类解析sql查询获取的数据结果
/** 获取本区督导病案核实失败数据* */ public String getKqBaFromGxsjrz(Map params) { List bldjglkInfoList=new ArrayList(); String ret = "0"; XStream xstream = new XStream(); xstrea原创 2018-01-19 11:05:50 · 368 阅读 · 0 评论 -
SQLSERVER数据库性能分析
–数据库性能分析 (https://blog.youkuaiyun.com/draling/article/details/8891322)–1.创建分析临时表CREATE TABLE #sp_who2(SPID INT,Status VARCHAR(255),Login VARCHAR(255),HostName VARCHAR(255),BlkBy VARCHAR(255),DBN...转载 2019-04-02 13:29:53 · 2380 阅读 · 0 评论 -
获取拼音码函数
/****** Object: UserDefinedFunction [dbo].[fun_getPY] Script Date: 04/03/2019 17:08:13 ******/IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fun_getPY]') AND type in (...原创 2019-04-03 17:12:06 · 520 阅读 · 0 评论 -
获取五笔码函数
/****** Object: UserDefinedFunction [dbo].[fun_getWBM] Script Date: 04/03/2019 17:08:52 ******/IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fun_getWBM]') AND type in...原创 2019-04-03 17:13:02 · 4315 阅读 · 0 评论