ビュー内ã§ORDER BYå¥ã‚’使用ã™ã‚‹: プãƒã‚°ãƒ©æ°‘。※SQL Server 2005ã§æ¤œè¨¼ ビューã®ä¸ã«ORDER BYå¥ã‚’記述ã™ã‚‹ã¨ä¸‹è¨˜ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã§ç™»éŒ²ã§ãã¾ã›ã‚“。 TOP ã¾ãŸã¯ FOR XML ãŒæŒ‡å®šã•ã‚Œã¦ã„ãªã„å ´åˆã€ãƒ“ューã€ã‚¤ãƒ³ãƒ©ã‚¤ãƒ³é–¢æ•°ã€æ´¾ç”Ÿãƒ†ãƒ¼ãƒ–ルã€ã‚µãƒ–クエリã€ãŠã‚ˆã³å…±é€šãƒ†ãƒ¼ãƒ–ルå¼ã§ã¯ ORDER BY å¥ã¯ç„¡åŠ¹ã§ã™ã€‚ ãŸã ã—ã€æŠœã‘é“ãŒã‚ã‚Š ROW_NUMBER() OVER (ORDER BY XXX) 㯠ä¸ã«ã•ã‚Šã’ãªã ORDER BY å¥ãŒã‚ã‚Šã¾ã™ãŒã€ã‚¨ãƒ©ãƒ¼ã«ãªã‚‰ãšã«ä¸¦ã³æ›¿ãˆã‚’è¡Œã†ã“ã¨ãŒå¯èƒ½ã§ã™ã€‚ ・・・ãã‚‚ãã‚‚ VIEW ã®ä¸ã§ ORDER BY ã—ãªãã¦ã‚‚〠SELECT ã™ã‚‹ã¨ãã« ORDER BY ã™ã‚Œã°è‰¯ã„ã˜ã‚ƒã‚“。ã£ã¦ãƒ„ッコミã¯ãªã—ã§ã™ã€‚ 例ãˆã°ã€ã¾ã•ã«ä»Šè‡ªåˆ†ãŒãã‚Œã§è€ƒãˆã¦ãŸã‚“ã§ã™ã‘ã©ã€ EUCã§ãƒ¦ãƒ¼ã‚¶ãŒãƒ„ール経由ã§ãƒ“ューã®çµæžœã‚’見ã«è¡Œãéš›ãªã©ã«å½¹ç«‹ã¤ã‹ã¨æ€ã„ã¾ã™ã€‚ é †ç•ªã®ã‚«ãƒ©ãƒ ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã®ãŒæ°—ã«ãªã‚‹ã‹
KB926292 - FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2008, the result is still returned in random order - Microsoft Support
å…¨ã¦ã¯æ™‚ã®ä¸ã«â€¦ : ã€SQL Server】指定ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ル一覧をå–å¾—ã™ã‚‹
https://support.microsoft.com/ja-jp/help/941800
★FFT風長門ã•ã‚“å£ç´™ : ããŸãŸã¾
{{#tags}}- {{label}}
{{/tags}}