T-SQL関連メモ - æŠ€è¡“æƒ…å ±Wikiselectã—ãªãŒã‚‰ãƒãƒƒã‚¯â€ Oracleã§è¨€ã† for update ã¯SQL Serverã«ã¯ç„¡ã„。ãã®ã‹ã‚ã‚Šã«with (updlock,tbllock)ãªã©ã‚’使ã†ã€‚ with (updlock) ã®ä½¿ç”¨ã«ã¤ã„㦠http://www.atmarkit.co.jp/bbs/phpBB//viewtopic.php?topic=27757&forum=26&7 ↑ selectã®æ¡ä»¶ã«æ£è¦è¡¨ç¾â€ http://homepage1.nifty.com/kojama/works/rdbms/mssql/sql.html#oterm01 全角åŠè§’区別ãªã©ã¯ã‚³ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³è¨å®šã®å½±éŸ¿ãŒã‚ã‚‹ã®ã§æ³¨æ„ select col from hoge --where col like '%[A-Z][0-9]%' --英大文å—ã«æ•°å—ãŒé€£çµã—ã¦ã„ã‚‹ --where col like '%[^A-Z][a-z]%
{{#tags}}- {{label}}
{{/tags}}