作者查詢 / a926
作者 a926 在 PTT [ Database ] 看板的留言(推文), 共160則
限定看板:Database
看板排序:
全部Soft_Job339Boy-Girl223Libra198CareerPlan190toberich178Database160C_Sharp133AllTogether108NFU92Mind77sex72Web_Design70WomenTalk68LUNA66CodeJob60Lineage60Tech_Job55Gossiping49Yunlin45Nantou43StupidClown36Hearthstone27Stock27LoL24soho24PC_Shopping21Wanted20CATCH19Programming19Palmar_Drama16home-sale15joke14Audiophile13Life13Flash12PHP12friends11GameDesign11KoreaDrama11Salary11poem10Beauty9lineageW9movie9Oversea_Job9Visual_Basic9WOW9BBSmovie8MuscleBeach8Network8ONE_PIECE8AndroidDev7share7wisdom78words6Android6CrazyArcade6hardware6nb-shopping6PushDoll6SMSlife6StarCraft6Ruby5firsttime4five_chess4FJU-ACC91a4HRM4marvel4NYUST4Cloud3FJU_AD-043FTP3Hate3HSNU_10083Lifeismoney3MenTalk3Notebook3Vietnam3WorkinChina3B873013XX2BigSanchung2car-pool2CCU-DEBATE2Examination2FCU_ECON_93B2FJU-Stat95A2FJU-STAT95B2Hotel2Japan_Travel2java2Jewelry2jingle2KS93-3202KS98-3022NCU97ME-B2NDHU-His952NDHU-His962NDHU-MSE922NetSecurity2NTUFM-862NTUT_EE490A2Perfume2PSJH5-3052RegExp2RSSH93_3012single2TFG01KONG2TigerBlue2TTU-I90B2VideoCard2wordtell2YP92-3022AION1AskBoard1bag1BioChem_951book1Broker1C_and_CPP1C_Chat1CCU-3DVG1CFP1CGSH86th3091CH7th3101chatskill1ck55th3051ck56th3041ck61st3091cksh78th201cksh81st3211cksh85th3171CM39th121CS15th3441CSMU-MIS951CSMU-N951CSMU-Psy1CTSH913011CTSH923011CTSH933021CYCU_EE_07A1CYCU_ICE90AB1D_Fin_Law_921DeathNote1Dragonica1Drama-Ticket1EdSheeran1Emulator1feminine_sex1FJU-ACCR941FJU-Laws951FJU_ADY2K1FJU_JCS81Foreign_Inv1ForeignEX1FSHS-95-3071Fund1Gamesale1H-GAME1happy1HardwareSale1HCHS543021HFU_me_89B1HSNU_10101HSNU_10481HSNU_10581HSNU_10731HSNU_10761HSNU_10981HSNU_11421HSNU_8541HSNU_9481HSNU_9571HSNU_HIGH1HTSH-7th3131HY29th3071ID_Problem1Itaiano-931JI3thN3-31kochikame1KS91-3051KS92-3041KS92-3111KS92-3131KS93-3041KUAS_IEM941License1Lottery1Mancare1marriage1MCU-LAW1MEMS424_95th1Mix_Match1Mo-Musume1mobilesales1mud1NCCU02_BA1NCCU03_BA1NCCU04_TUR1NCCU06_BA1NCCU_C-Baske1NCCU_ChungYo1NCHU-AGR001NCUPhysics1NDHU-EE931NDHU-phy991NDMC-M1031NDMC-PH251NIUECE911NTCYSG1NTHU-MSE101NTHU-YP1ntnuHE951NTUAC871NTUE-CEE971NTUHorti961NTUST-EE-B911NTUST-ET-B881NTUT_en489b1NUU_MSE1NUU_Talk1Old_Egg1Option1Ordnance54-21PokeMon1PoleStar1rent-exp1Rent_tao1RESIT1RSSH91_3011RSSH93_3051score1SCU-BM-87B1SCU-BM-93B1SCU_chem901scuCGbasket1shoes1SportLottery1SSSH-16th3131Storage_Zone1STU1t-management1TA_AN1Tai-travel1Tainan1TaiwanJobs1THU-HIS971THU_BA20001THU_Talk1TIT1TOEIC1Trading1travel1TTU-I91A1TVClass1TYSH50-3031WuLing46-3171You_out1YP-SCU1YP92-3041YP92-3121Yup01-061<< 收起看板(261)
5F→: gname大 千萬不要相信你的電腦不會遇到鬼啊 XD01/23 11:09
4F推: 除非Query效能低落才會考慮拆表說11/28 10:42
1F→: 你是用sql語法新增資料還是由code新增資料?11/22 10:22
4F推: 用termimal進去看的話 中文也是亂碼?11/18 14:11
3F→: join代表兩張表之間是有關聯性的存在。你這兩張表有關係嗎@@10/19 20:04
1F→: 看不太懂你要做什麼事09/26 17:26
2F→: 照你測試的方式.你要先測你的clinet可否正確連到你的SQL srv09/26 17:27
6F→: 先查你的RAM使用狀況,因為你資料查詢時會預載至RAM中09/19 13:27
7F→: RAM接近滿載時,執行速度會變慢09/19 13:28
8F→: 另外可以參考執行計畫去建你Table的索引09/19 13:28
1F推: 我會建議你先買書來看09/15 10:59
2F→: 先看SQL server 2012 設計實務跟管理實務09/15 10:59
3F→: 先看完書對SQL資料庫有基礎認識再去上課比較好09/15 11:00
1F→:先做個index看看?05/15 11:44
2F→:另外記憶體 cpu相關的設定有查過嗎@@05/15 11:44
3F→:不過我是mssql的使用者就是了..其它可能要請mysql的出面說了05/15 11:45
1F推:看不太懂你描述的問題點05/09 13:52
2F→:這個WHERE只是單純讓你條件去串College05/09 13:52
3F→:所以College不用出現在FROM當中05/09 13:53
4F→:如果College沒有出現在FROM當中,你SELECT該表的欄位05/09 13:54
5F→:會出錯才是. 你可以試看看 : ) 有錯還請大家幫忙指正05/09 13:54