- 博客(5)
- 收藏
- 关注
原创 由身份证读取当天生日
private string getBirthdayName() { string getName = ""; ; string cmdString = "select name from new_employee where substring(idcard,11,4)='" + DateTime.Now.Date.ToString("MMdd")
2012-02-29 23:23:41 253
转载 重复记录和处理
1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断select * from peoplewhere peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)2、删除表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断,只留有ro
2012-02-23 16:05:37 236
转载 监视数据库性能的几个sql
1. 监控事例的等待 select event,sum(decode(wait_Time,0,0,1)) "Prev", sum(decode(wait_Time,0,1,0)) "Curr",count(*) "Tot" from v$session_Wait group by event order by 4; 2. 回滚段的争用情况 select nam
2012-02-23 16:02:42 224
转载 更新不同表相同字段不同值
UPDATE SA.SUBMIT SA SET SEND_STATE = (SELECT SEND_STATE FROM PHS.SUBMIT WHERE PHS.SUBMIT.ID = SA.ID AND SUBSTR(SA.SEND_STATE
2012-02-23 16:00:52 323
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人