作者查詢 / rockchangnew
作者 rockchangnew 在 PTT 全部看板的留言(推文), 共3344則
限定看板:全部
看板排序:
全部Gossiping1808HatePolitics990Database225HsinChuang60movie59FJU_CLASS44FJU35TaiwanDrama25Olympics_ISG22Baseball12nCoV20196iOS4WindowsPhone4CMWang3FJU-STAT95B3FJU-Stat97A3FJU_NIGHT3home-sale3L_TalkandCha3Militarylife3NTUT_EE493A3NTU2Shu-Lin2ShuangHe2Tennis2Tour-Manager2Zombie2BigSanchung1car1CrossStrait1DJ_fightman1EatToDie1gay1Golden-Award1Japandrama1MLB1MobileComm1PublicIssue1sex1Stock1Zhongshan1<< 收起看板(41)
3F推:Y大的寫法只能建立在資料不重複下,如有兩筆3/C就完07/17 23:10
4F→:了07/17 23:10
5F→:select a.id from tb1 a07/17 23:13
6F→:inner join tb1 b on a.id=b.id and b.value='B'07/17 23:14
7F→:inner join tb1 c on a.id=c.id and c.value='C'07/17 23:15
8F→:inner join tb1 d on a.id=d.id and d.value='D'07/17 23:16
9F→:group by a.id07/17 23:16
4F推:不轟老布是因為轟不到,那一種槍射程不夠。10/21 21:42
77F噓:好看06/26 21:44
2F推:bulk insert作用是大量匯入資料時不記錄交易紀錄檔吧06/20 21:10
3F→:常看見SQL大師們也會用while迴圈一次新增好幾千筆06/20 21:12
4F推:http://ptt.cc/-Q5106/20 21:19
5F推:http://ppt.cc/-Q5106/20 21:22
6F推:必修帶入都是系秘進系統帶的06/18 22:38
7F推:L大正解,話說你老闆膽子算大顆歐06/20 20:49
5F推:聽說船老大要開在以前昱帝嶺的地方歐06/12 22:31
6F推:要是我會寫TSQL來匯吧,彈性比較大06/20 20:57
20F推:九號丼坊不錯吃05/31 18:54
3F推:八月分06/02 16:22