作者查詢 / rockchangnew
作者 rockchangnew 在 PTT [ Database ] 看板的留言(推文), 共225則
限定看板:Database
看板排序:
全部Gossiping1804HatePolitics990Database225HsinChuang60movie59FJU_CLASS44FJU35TaiwanDrama25Olympics_ISG22Baseball12nCoV20196iOS4WindowsPhone4CMWang3FJU-STAT95B3FJU-Stat97A3FJU_NIGHT3home-sale3L_TalkandCha3Militarylife3NTUT_EE493A3NTU2Shu-Lin2ShuangHe2Tennis2Tour-Manager2Zombie2BigSanchung1car1CrossStrait1DJ_fightman1EatToDie1gay1Golden-Award1Japandrama1MLB1MobileComm1PublicIssue1sex1Stock1Zhongshan1<< 收起看板(41)
2F推: select dep_code,dep_name,staff_code,staff_name,d03/08 00:03
3F→: iv_code,sum(num) 然後group by dep_code,dep_name,03/08 00:03
4F→: staff_code,staff_name,div_code03/08 00:03
1F推: 介意用store procedure做嗎?03/06 12:04
1F推: http://goo.gl/gq3QAc03/01 21:21
4F推: https://dotblogs.com.tw/rainmaker/2014/10/22/14702/17 23:19
5F→: 05502/17 23:19
6F→: 縮址一下 https://goo.gl/vuMVlE02/17 23:20
9F推: https://goo.gl/AJvOZK02/17 23:35
11F推: https://goo.gl/photos/g2fzanWgxB4zmfAG902/18 11:49
12F推: 我的做法還是有BUG啦02/18 11:52
13F推: 我想到另一個做法就是A-1轉A-01然後在排序02/18 11:55
1F推: 不要用openquery的方式update呢?01/12 19:20
2F→: 直接用4層架構update呢?01/12 19:21
2F推: 搜尋一下 dacpac01/11 18:04
1F推: https://goo.gl/photos/qQPBCsuc98dyboFV612/09 23:25
2F推: select ename,dname from 員 left join 部 on12/06 09:06
3F→: 員.did=部.did order by ename,dname12/06 09:08
3F推: 不利搜尋,每筆計錄都要算,索引用不上11/28 20:06