作者查詢 / rockchangnew
作者 rockchangnew 在 PTT [ Database ] 看板的留言(推文), 共225則
限定看板:Database
看板排序:
全部Gossiping1810HatePolitics990Database225HsinChuang60movie59FJU_CLASS44FJU35TaiwanDrama25Olympics_ISG22Baseball12nCoV20196iOS4WindowsPhone4CMWang3FJU-STAT95B3FJU-Stat97A3FJU_NIGHT3home-sale3L_TalkandCha3Militarylife3NTUT_EE493A3NTU2Shu-Lin2ShuangHe2Tennis2Tour-Manager2Zombie2BigSanchung1car1CrossStrait1DJ_fightman1EatToDie1gay1Golden-Award1Japandrama1MLB1MobileComm1PublicIssue1sex1Stock1Zhongshan1<< 收起看板(41)
11F推:Mssql是沒影響,index的欄位排序才是重點05/10 20:24
13F推:資料庫沒那麼爛,鐵定是沒正確的index04/03 13:33
3F推:建議該欄位可以利用function來達到04/02 10:26
5F→:為何會認為文字檔大小一定等於資料表大小呢?01/03 15:16
6F→:請您先算出每一ROW的大小,在乘與資料筆數才對。01/03 15:17
3F推:你的寫法並不是子查詢,是簡化Inner Join的語法11/23 00:44
1F推:改成 if @param is null呢?11/20 20:17
6F推:這應該是要用store procedure來做吧11/04 21:25
2F推:樓上正解10/26 12:23
2F推:如果是MSSQL的話,查一下CTE語法,專門遞迴用,讚10/14 20:51
7F→:千萬別用linked server來join,請先用openquery來做09/30 20:21