SQL æåé¢æ° - é£çµã空ç½åé¤ãç½®æãååºãæ¤ç´¢ãé·ããæ°å¤å¤æä» åºæ¬çã« OracleãSQL-ServerãMDB ã§å ±éã§ãã â æååé£çµ ã»concat() é¢æ°ã¯ãæååãçµåããããçµæãè¿ãã ã||ãæ¼ç®åã®æ¹ãç°¡åã¨æããã©ãã§ãããã (Access ã§ã¯ ã&ãã使ç¨ããã) select åçª, concat('part-', åçª), 'part-' || åçª from sak.å注m order by åçª ; â chr æåå¤æ ã»chr() é¢æ°ã¯ãã³ã¼ãã«è©²å½ãã ASCII æåãè¿ãã ãã®ä¾ã§ã¯ãã1ãã¨è¨ãæåãè¿ãã select åçª, chr(49) from sak.å注m order by åçª ; â ascii ã³ã¼ãå¤æ ã»ascii() é¢æ°ã¯ãæåã«è©²å½ãã ASCII ã³ã¼ããè¿ãã ãã®ä¾ã§ã¯ãã49ãã¨è¨ãæ°åã
{{#tags}}- {{label}}
{{/tags}}