[B! sqlserver] taketsã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

takets id:takets

sqlserverã«é–¢ã™ã‚‹taketsã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Ruby ã§ SQL Server ã‚’æ‰±ã†ï¼ˆWindowsï¼‰ | zu-min.com
Windows ã§ Ruby Installer ã‚’ä½¿ã£ã¦ã„ã‚‹å ´åˆã®æ‰‹é †ã§ã™ã€‚Ruby ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 2.x ç³»ã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ã¾ãšã¯ gem ã§ rdbi-driver-odbc ã‚’å…¥ã‚Œã¾ã™ã€‚ gem install rdbi gem install rdbi-driver-odbc DEVELOPMENT KIT ã‚’å…¥ã‚Œã‚ã¨æ€’ã‚‰ã‚ŒãŸå ´åˆ DEVELOPMENT KIT ãŒãªã„å ´åˆã¯ä»¥ä¸‹ã®ã‚ˆã†ãªã‚¨ãƒ©ãƒ¼ãŒå‡ºã¦ãã¾ã™ã€‚ Please update your PATH to include build tools or download the DevKit from 'http://rubyinstaller.org/downloads' and follow the instructions at 'http://github.com/oneclick/rubyinstaller/wik
takets 2017/07/27
rdbiã¨ã„ã†gemã‚’ä½¿ã†ã‚‰ã—ã„ã€‚ã“ã‚Œã ã‘ã§ã„ã‘ã‚Œã°ã“ã‚Œã§ã„ããŸã„ã¨ã“ã‚ã€‚

ruby

sqlserver
ãƒªãƒ³ã‚¯
Ruby + DBI + Sql Server + Windows â€” zhongxiao37 0.1 documentation
takets 2017/07/27
ã“ã¡ã‚‰ã¯dbiã‚’ä½¿ã†æ–¹å¼

ruby

sqlserver
ãƒªãƒ³ã‚¯
Rubyã‹ã‚‰SQLServerã®ã‚¹ãƒˆã‚¢ãƒ‰ã‚’å‘¼ã³å‡ºã™ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
takets 2017/07/27
ruby

sqlserver
ãƒªãƒ³ã‚¯
Ruby Driver - Ruby driver for SQL Server
takets 2017/07/27
rubyã§sqlserverã«æŽ¥ç¶šã™ã‚‹â€•â€•ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆå…¬å¼ã®ã‚„ã‚Šã‹ãŸ

ruby

sqlserver
ãƒªãƒ³ã‚¯
Ruby 1.9.3 ã§ Microsoft SQL Server ã« ODBC æŽ¥ç¶šã™ã‚‹
Ruby 1.9.3 ã§ Microsoft SQL Server ã« ODBC æŽ¥ç¶šã™ã‚‹ 2015/04/08 08:12 å¼•ãç¶šã Ruby ã§ã‚¯ãƒãƒ¼ãƒªãƒ³ã‚°ã¨ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°ã®å‹‰å¼·ä¸ã§ã™ã€‚ FM ãƒ©ã‚¸ã‚ª 3 å±€ã®ãã®æ—¥ã®å†ç”Ÿæ›²ãƒªã‚¹ãƒˆã‚’æŠ½å‡ºã™ã‚‹ã¨ã„ã†æ©Ÿèƒ½ã¯ CLI + CSV ãƒ™ãƒ¼ã‚¹ã§å®Ÿè£…ã§ãã¾ã—ãŸã€‚ ã¾ã æ˜Žç¢ºãªã‚¢ã‚¦ãƒˆãƒ—ãƒƒãƒˆã®ã‚¤ãƒ¡ãƒ¼ã‚¸ã¯ãªã„ã‚“ã§ã™ãŒã€ãƒ‡ãƒ¼ã‚¿ã®æ°¸ç¶šåŒ–ã‚„å†åˆ©ç”¨ã¨ã„ã†æ„å‘³ã§ã¯ã‚„ã¯ã‚Šãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã„ãŸã„ã¨ã“ã‚ã€‚ PHP ã®å‹‰å¼·ã§ MySQL ã«è§¦ã‚Œã¾ã—ãŸã€‚ ã¨ã¯ã„ãˆä»•äº‹ã®é–¢ä¿‚ã§ Microsoft SQL Server ã«ãªã˜ã¿ãŒæ·±ã„ã®ã§ã€ã§ãã‚Œã° MSSQL ã§é‹ç”¨ã™ã‚‹æ‰‹æ³•ã‚’ç¢ºç«‹ã—ã¦ãŠããŸã„ã€‚ Ruby 1.9.3 ã§ MSSQL ã«æŽ¥ç¶šã™ã‚‹ã¨ã„ã† tips ã§ã“ã‚Œã¨ã„ã†ã‚‚ã®ãŒãªã‹ãªã‹è¦‹ã¤ã‘ã‚‰ã‚Œãšã«ã„ã¾ã—ãŸãŒã€ã‚„ã£ã¨æœ¬æ—¥å–ã£æŽ›ã‹ã‚Šã‚’å¾—ã¾ã—ãŸã€‚ å‚™å¿˜éŒ²ã‚‚å…¼ãã¤ã¤ã€ä»Šå¾ŒåŒã˜ã‚ˆã†ã«æ‰‹
takets 2017/07/27
windowsç’°å¢ƒã§rubyã‹ã‚‰sqlserverã«æŽ¥ç¶šã™ã‚‹æ–¹æ³•

ruby

sqlserver
ãƒªãƒ³ã‚¯
CREATE INDEX (SQL Server Compact)
æŒ‡å®šã•ã‚ŒãŸãƒ†ãƒ¼ãƒ–ãƒ«ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆã—ã¾ã™ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«å†…ã«ãƒ‡ãƒ¼ã‚¿ãŒãªãã¦ã‚‚ä½œæˆã§ãã¾ã™ã€‚ æ§‹æ–‡ CREATE [UNIQUE] [NONCLUSTERED] INDEX index_name ON table_name (column_name [ASC|DESC][,â€¦n]) WITH (STATISTICS_NORECOMPUTE = { ON | OFF })] å¼•æ•° ãƒ†ãƒ¼ãƒ–ãƒ«ã«ä¸€æ„ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆã—ã¾ã™ã€‚ä¸€æ„ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ã€2 ã¤ã®è¡Œã«åŒã˜ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å€¤ãŒè¨±å¯ã•ã‚Œãªã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§ã™ã€‚ SQL Server Compact ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãŒæ—¢ã«å˜åœ¨ã™ã‚‹å ´åˆã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½œæˆã•ã‚ŒãŸã¨ãã€ãŠã‚ˆã³ INSERT ã¾ãŸã¯ UPDATE ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’ä½¿ç”¨ã—ã¦ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ ã™ã‚‹ãŸã³ã«ã€é‡è¤‡å€¤ãŒãªã„ã‹ã©ã†ã‹ãŒãƒã‚§ãƒƒã‚¯ã•ã‚Œã¾ã™ã€‚åˆ—ã«ä¸€æ„ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆã™ã‚‹ã«ã¯ã€å…ˆã«é‡
takets 2017/06/27
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œæˆæ–¹æ³•åŸºç¤Ž

sqlserver
ãƒªãƒ³ã‚¯
1