作者查詢 / ishewood
作者 ishewood 在 PTT [ Database ] 看板的留言(推文), 共17則
限定看板:Database
看板排序:
全部T-ara785BLACKPINK221WorldCup204YG_Ent102Gossiping84KoreaStar78book63CLC38KoreanPop38sinica36EAseries32KoreaDrama27Database17NY-Yankees15INFINITE12Moto_GP11StupidClown10SunnyHill10UEFA10Wine9car-pool8KR_Entertain8Liu8ADS7ONE_PIECE7DSLR6stationery6AntiVirus5Davichi4Fund4HatePolitics4LCD4Badminton3GFRIEND3KS97-3083Architecture2Argentina2ask2CN_Entertain2CompBook2Detective2FORMULA12Instant_Mess2Palmar_Drama2part-time2Road_Running2Visual_Basic2Anchors1Ancient1biker1BLOWSPEED1Childhood1Design1e-coupon1FJU-LS94b1ForeignEX1JPliterature1KS92-3151KS94-3021KS94-3111Native1nb-shopping1NBA1NCCU04_GID1NCCU07_SW1NCCU08_JAPAN1NDHU-phy931NDHU_MSE941Office1Olympics_ISG1photo1pighead1share1Shu-Lin1ShuangHe1Soft_Job1SongShan1specialman1SuperJunior1Supermission1TaiwanDrama1TamShui1THULAW1TryingTimes1WoodworkDIY1<< 收起看板(85)
首頁
上一頁
1
下一頁
尾頁
5F→: 把list轉成兩欄的暫時表,再去join11/13 00:28
6F→: 1樓作法要小心'abcxyz'=('abc'+'xyz') or ('ab'+'cxyz')11/13 00:29
1F→: SELECT table_name, field_name,10/12 15:48
2F→: ROW_NUMBER() OVER(10/12 15:49
3F→: PARTITION BY table_name ORDER BY field_name10/12 15:50
4F→: ) AS sequence10/12 15:50
5F→: FROM table_schema10/12 15:50
6F→: ORDER BY table_name, field_name;10/12 15:51
7F→: 看是不是你要的10/12 15:51
1F→:T-SQL有ISNOTNULL函數?03/23 11:18
1F推:REPLACE(Prod, '-', '') 請善用help找字串函數09/28 19:43
2F→:visio可以作反向工程11/20 10:07
1F→:access在資料量大時,查詢效能很差,跟硬體關係不大11/13 12:07
3F→:同樣的查詢,在access要十幾分鐘,改sqlserver專案1、2秒11/13 14:17
2F推:撇開安全性(不熟) 兩張網卡一內一外運作AC+SQL是ok的05/12 18:14
3F推:加上[] like '%[_]%'03/23 00:26
2F推:工具→資料庫工用程式→壓縮及修復資料庫08/27 10:11
首頁
上一頁
1
下一頁
尾頁