作者查詢 / tw70126
作者 tw70126 在 PTT [ Database ] 看板的留言(推文), 共15則
限定看板:Database
看板排序:
全部Web_Design83Gossiping46car27CYCU_MIS_93A15Database15FITNESS13Soft_Job9Softball9NLHS-Chat7BuyTogether5CGI-Game3iOS3Japan_Travel3GRE2HatePolitics2home-sale2joke2Loan2MLB2mobilesales2PSP-PSV2B96310XXX1BeautyBody1CarShop1CCF1ChungLi1ck_17_3011CLHS-55-3201CSMU-D951CSMU-MED951Cycu_Trans1FJU-Laws941FJU-Stat95A1FJU-STAT95B1FJU_JCS111Hearthstone1HSNU_10661HSNU_10811HSNU_11091Insurance1LifeSci_961MCU-LAW1NCCU07_DIP1NCHU-FS1001NDHU-phy991NFU1Nintendo1NTPU-STAT951NTUBSE-B-961NTUMEB951NTUMEB961NTUST-ET-A961NTUST_Talk1PttLifeLaw1STU1studyabroad1TFSHS65th3061TFSHS65th3201TKU_trans1VAPE1Viator93Chia1WarCraft1<< 收起看板(62)
2F推:先找這些資料的共通性找出來,造出資料庫之後就簡單囉10/25 22:15
4F推:我猜是 @InputIndex 出錯,看看試不是傳了空直進來10/04 10:16
1F推:union all10/03 10:15
2F推:日期要 convert 成同一種格式才能比09/22 00:55
1F→:會到N個欄位就是資料表設計不良了吧 = =09/14 14:04
4F推:如果用INSTR 找空白呢??09/16 13:53
5F推:year in (2008,2009,2010) and month in (1~8)09/10 23:39
3F→:好像要把TXT的內容改掉....年代久遠 你上網找找吧 = =09/01 00:17
1F推:這要用到 temp table 才有解了吧..........08/11 13:02
3F推:日期跟時間拆開來....一個 and 就夠了07/29 21:00