作者查詢 / rockchangnew
作者 rockchangnew 在 PTT [ Database ] 看板的留言(推文), 共225則
限定看板:Database
看板排序:
全部Gossiping1810HatePolitics990Database225HsinChuang60movie59FJU_CLASS44FJU35TaiwanDrama25Olympics_ISG22Baseball12nCoV20196iOS4WindowsPhone4CMWang3FJU-STAT95B3FJU-Stat97A3FJU_NIGHT3home-sale3L_TalkandCha3Militarylife3NTUT_EE493A3NTU2Shu-Lin2ShuangHe2Tennis2Tour-Manager2Zombie2BigSanchung1car1CrossStrait1DJ_fightman1EatToDie1gay1Golden-Award1Japandrama1MLB1MobileComm1PublicIssue1sex1Stock1Zhongshan1<< 收起看板(41)
4F推: Select @version04/14 18:11
5F→: Select @@version才對04/14 18:11
6F推: 顯示是Standard版,版本差異 http://ppt.cc/cVUV04/15 14:28
7F→: 你說的4G是記憶體,資料庫容量Express版可到10G04/15 14:29
1F推: 可參考一下這一篇 http://ppt.cc/S9mP04/15 14:32
9F推: 可拆,會減少資料量。日後維護也方便03/22 14:11
1F推: Ms sql可以,請查over關鍵字02/19 09:50
1F推: 基本上建議指名欄位,用*較不建議02/07 17:13
1F推: 會是A02/04 22:59
1F推: NO,只能用sysprocesses去看hostname02/03 21:58
18F推: 請直接打IP,先別打電腦名稱02/02 19:23
1F推: 先確認sql的1433有開防火牆嗎?01/31 18:40
2F→: 再來就是確認instance name有無打錯01/31 18:41
3F推: "SELECT .... Like '%" & YMNum & "%'"01/28 20:18