[B! sql] hiroponzã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hiroponz id:hiroponz

sqlã«é–¢ã™ã‚‹hiroponzã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (33)

${{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}}

Why SQL is beating NoSQL and what this means for the future of data
PostgreSQL, but faster. Built for lightning-fast ingest and querying of time-based data. Timeseries and analytics
hiroponz 2017/09/28
SQL
ãƒªãƒ³ã‚¯
Format SQL Statements Online - sqlformat.org
SQLFormat is a free online formatter for SQL statements. Enter your SQL statement in the textarea below and click "Format SQL" [Ctrl+Enter]. To upload a file use the button right below the textarea. In addition to this web interface SQLFormat provides an API. Or you can download the Python module that powers this service to use it in your own applications. See source code for details.
hiroponz 2017/09/01
ä¾¿åˆ©ï¼

sql
ãƒªãƒ³ã‚¯
Whatâ€™s New in SQL:2016
In December 2016, ISO released a new version of the international SQL standard (ISO/IEC 9075:2016). It supersedes the previous version from 2011. This article is a brief overview of the new features being introduced into the SQL language. Strictly speaking, this article covers the additions to part 2 of the standard (SQL/Foundation), i.e. the most commonly used part. This article also shows the av
hiroponz 2017/07/11
sql
ãƒªãƒ³ã‚¯
ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç–ï½œãƒã‚¤ã‚¯ãƒ©ã‚¹è»¢è·ãƒ»æ±‚äººæƒ…å ±ã‚µã‚¤ãƒˆ AMBIï¼ˆã‚¢ãƒ³ãƒ“ï¼‰
ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç– ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã®æ¾æµ¦éš¼äººã•ã‚“ã«ã€8ã¤ã®ã€ŒSQLãŒé‡ãŸããªã‚‹åŽŸå› ã¨ãã®å¯¾ç–ã€ã‚’èžãã¾ã—ãŸã€‚ã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã‚‹ã‚ˆã†ãªã€Œå•é¡Œã®ã‚ã‚‹SQLã€ã‚’å›žé¿ã™ã‚‹ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã³ã¾ã—ã‚‡ã†ã€‚ ãƒ‡ãƒ¼ã‚¿ã®æ“ä½œã‚„å®šç¾©ã‚’ã™ã‚‹è¨€èªžã€ŒSQLã€ã¯ã€ã©ã®ã‚ˆã†ãªé ˜åŸŸã‚’æ‹…ã†ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¨ã£ã¦ã‚‚å¿…ä¿®ç§‘ç›®ã§ã™ã€‚ã—ã‹ã—ã€ãã®ä»•æ§˜ã‚’ãã¡ã‚“ã¨ç†è§£ã—ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å„ªã‚ŒãŸSQLã‚’æ›¸ã‘ã‚‹æ–¹ã¯ãã‚Œã»ã©å¤šãã‚ã‚Šã¾ã›ã‚“ã€‚å•é¡Œã®ã‚ã‚‹SQLã‚’æ›¸ã„ã¦ã—ã¾ã„ã€çŸ¥ã‚‰ã¬é–“ã«ãã‚ŒãŒã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ã—ã¾ã†äº‹æ…‹ã¯ã‚ˆãç™ºç”Ÿã—ã¾ã™ã€‚ ã§ã¯ã€ã©ã†ã™ã‚Œã°ãã†ã—ãŸäº‹æ…‹ã‚’å›žé¿ã§ãã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãã®ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã¶ãŸã‚ã€ä»Šå›žã¯ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã§ã‚ã‚Šã€è‡ªèº«ã‚‚ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚‚ã‚ã‚‹æ¾æµ¦éš¼äººï¼ˆã¾ã¤ã†ã‚‰ãƒ»ã¯ã‚„ã¨ï¼@dblmktï¼‰ã•ã‚“ã«8ã¤
hiroponz 2017/06/27
sql

performance
ãƒªãƒ³ã‚¯
Buckblog: Introducing the Query Composer
hiroponz 2016/04/13
gem

sql
ãƒªãƒ³ã‚¯
Raw SQL in a Rails project | Climbing atop the Shoulders of Giants
hiroponz 2016/02/18
rails

sql
ãƒªãƒ³ã‚¯
å·¨å¤§ãªãƒãƒƒãƒã‚’åˆ†å‰²ã—ã¦æ§‹æˆã™ã‚‹ ã€œSQLãƒãƒƒãƒãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯Bricolageã€œ - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ãƒˆãƒ¬ãƒ³ãƒ‰èª¿æŸ»ãƒ©ãƒœã®é’æœ¨å³°éƒŽï¼ˆid:mineroaokiï¼‰ã§ã™ã€‚ å¥½ããªRubyã®ãƒ¡ã‚½ãƒƒãƒ‰ã¯10å¹´å‰ã‹ã‚‰String#slice(re, nth)ã§ã™ãŒã€ æœ€è¿‘ã¯Rubyã‚ˆã‚ŠCoffeeScriptã¨SQLã®ã»ã†ãŒæ›¸ãé‡ãŒå¤šãã¦æ‚©ã‚“ã§ã„ã¾ã™ã€‚ ä»Šæ—¥ã¯ã‚ãŸã—ãŒé–‹ç™ºã—ã¦ã„ã‚‹ã€ŒãŸã¹ã¿ã‚‹ã€ã®èƒŒå¾Œã§åƒã„ã¦ã„ã‚‹ å·¨å¤§ãƒãƒƒãƒã®æ§‹æˆã«ã¤ã„ã¦è©±ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ãŸã¹ã¿ã‚‹ã®ãƒãƒƒãƒã¯ç´„3000è¡Œã®SQLã§æ§‹æˆã•ã‚Œã¦ãŠã‚Šã€ å‡¦ç†æ™‚é–“ãŒ1æ—¥ã§4æ™‚é–“ç¨‹åº¦ã‹ã‹ã‚‹ã€ãã“ãã“ã®è¦æ¨¡ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã™ã€‚ ã“ã®ãƒãƒƒãƒå‡¦ç†ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’Bricolageï¼ˆãƒ–ãƒªã‚³ãƒ©ãƒ¼ã‚¸ãƒ¥ï¼‰ã¨ã„ã†ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã§æ§‹é€ åŒ–ã™ã‚‹æ‰‹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ ã€ŒãŸã¹ã¿ã‚‹ã€ã¨ã¯ ã¾ãšæœ€åˆã«ã€ã€ŒãŸã¹ã¿ã‚‹ã€ãŒã©ã†ã„ã†ã‚‚ã®ãªã®ã‹ã”ãç°¡å˜ã«ãŠè©±ã—ã—ã¦ãŠãã¾ã—ã‚‡ã†ã€‚ ã€ŒãŸã¹ã¿ã‚‹ã€ã¯ä¼æ¥ã®ã¿ã«æä¾›ã—ã¦ã„ã‚‹B2Bã®åˆ†æžã‚µãƒ¼ãƒ“ã‚¹ã§ã€ ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã®ãƒ¬ã‚·ãƒ”æ¤œç´¢ã®åˆ†æžã‚’ã™ã‚‹ã“ã¨ãŒã§ãã¾
hiroponz 2015/06/28
sql

cookpad

batch
ãƒªãƒ³ã‚¯
æƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ï¼šæƒ…å ±ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ï¼šè„†å¼±æ€§å¯¾ç–ï¼šå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹
ã€Œå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€ã¯ã€IPAãŒå±Šå‡º(*1)ã‚’å—ã‘ãŸè„†å¼±æ€§é–¢é€£æƒ…å ±ã‚’åŸºã«ã€å±Šå‡ºä»¶æ•°ã®å¤šã‹ã£ãŸè„†å¼±æ€§ã‚„æ”»æ’ƒã«ã‚ˆã‚‹å½±éŸ¿åº¦ãŒå¤§ãã„è„†å¼±æ€§ã‚’å–ã‚Šä¸Šã’ã€ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆé–‹ç™ºè€…ã‚„é‹å–¶è€…ãŒé©åˆ‡ãªã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚’è€ƒæ…®ã—ãŸã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã‚’ä½œæˆã™ã‚‹ãŸã‚ã®è³‡æ–™ã§ã™ã€‚ ã€Œå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€æ”¹è¨‚ç¬¬7ç‰ˆã®å†…å®¹ ç¬¬1ç« ã§ã¯ã€ã€Œã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å®Ÿè£…ã€ã¨ã—ã¦ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ ã€OSã‚³ãƒžãƒ³ãƒ‰ãƒ»ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ ã‚„ã‚¯ãƒã‚¹ã‚µã‚¤ãƒˆãƒ»ã‚¹ã‚¯ãƒªãƒ—ãƒ†ã‚£ãƒ³ã‚° ç‰11ç¨®é¡žã®è„†å¼±æ€§ã‚’å–ã‚Šä¸Šã’ã€ãã‚Œãžã‚Œã®è„†å¼±æ€§ã§ç™ºç”Ÿã—ã†ã‚‹è„…å¨ã‚„ç‰¹ã«æ³¨æ„ãŒå¿…è¦ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ç‰¹å¾´ç‰ã‚’è§£èª¬ã—ã€è„†å¼±æ€§ã®åŽŸå› ãã®ã‚‚ã®ã‚’ãªãã™æ ¹æœ¬çš„ãªè§£æ±ºç–ã€æ”»æ’ƒã«ã‚ˆã‚‹å½±éŸ¿ã®ä½Žæ¸›ã‚’æœŸå¾…ã§ãã‚‹å¯¾ç–ã‚’ç¤ºã—ã¦ã„ã¾ã™ã€‚ ç¬¬2ç« ã§ã¯ã€ã€Œã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®å®‰å…¨æ€§å‘ä¸Šã®ãŸã‚ã®å–ã‚Šçµ„ã¿ã€ã¨ã—ã¦ã€ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒã®é‹ç”¨ã«é–¢ã™ã‚‹å¯¾ç–ã‚„ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã«ãŠã‘ã‚‹ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®å–æ‰±ã„ã«é–¢ã™
hiroponz 2010/06/28
å®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã«ã¤ã„ã¦ã€‚æŒ‡å°Žè€…å‘ã‘ã®è³‡æ–™

*study

security

sql
ãƒªãƒ³ã‚¯
Tips - LINQ to SQL ã® DataContext ã‚’ä½¿ã£ã¦ã€ãŠæ‰‹è»½ O/R ãƒžãƒƒãƒ”ãƒ³ã‚° | @jsakamoto
å®Ÿã¯è‡ªåˆ†ã¯ LINQ å¤§å¥½ãã§ã‚ã‚‹ã€‚ LINQ ã®ä½¿ãˆãªã„ C# ãªã‚“ã¦ã‚‚ã†è€ƒãˆã‚‰ã‚Œãªã„ã€‚ ã‚‚ã¨ã‚‚ã¨ Prolog ã‚„ Haskell ã®ä½“é¨“ã‚‚ã‚ã‚Šã€ã¾ãŸã€SQL ã¯å¥½ã‚“ã§ãµã‚“ã ã‚“ã«ä½¿ã†ã—ã€jQuery ã®ã‚»ãƒ¬ã‚¯ã‚¿ä¸‡æ³ãªã®ã§ã€å®£è¨€æŒ‡å‘ã€How ã‚ˆã‚Š Whatã€é›†åˆæ“ä½œã¯å¤§å¥½ãã§ã‚ã‚‹ã€‚ å½“ç„¶ã®ã”ã¨ãã€LINQ to SQL ã‚„ LINQ to Entity ã‚‚å¤šç”¨ã™ã‚‹ã€‚ ã—ã‹ã—ã€ã§ã‚ã‚‹ã€‚ å°ç²’ã§ã‚¢ãƒ‰ãƒ›ãƒƒã‚¯ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã® SELECT ã‚¯ã‚¨ãƒªã‚’ã€ã•ã•ã£ã¨æ›¸ããŸã„ã¨ãã‚‚ã‚ã‚‹ã€‚ æ˜”ãªãŒã‚‰ã« DataAdaptor ãªã©ã‚’ä½¿ã„ãªãŒã‚‰ DataSet ã‚„ DataTable ã§çµæžœã‚’å…¥æ‰‹ã—ã¦ã‚‚ã‚ˆã„ã®ã ãŒã€ã‚·ãƒ³ãƒ—ãƒ«ãªã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã«ãƒžãƒƒãƒ—ã§ããŸã»ã†ãŒã€ã‚¤ãƒ³ãƒ†ãƒªã‚»ãƒ³ã‚¹ä¸æ¯’ã§ã‚ã‚‹è‡ªåˆ†ã«ã¨ã£ã¦ã¯å¤§å¤‰æ¥½ã§ã‚ã‚‹ã€‚ ã¨ãªã‚Œã° LINQ to SQL ã®å‡ºç•ªãªã®ã ãŒã€ã—ã‹ã—ã€ãŸã‹ã ã‹ãã‚Œã ã‘ã®ãŸã‚ã« .dtml ã‚’
hiroponz 2010/01/12
*programming

tips

C#

linq

sql
ãƒªãƒ³ã‚¯
https://support.microsoft.com/ja-jp/help/155512
ã™ã¹ã¦ Microsoft è£½å“ Microsoft 365 Office Windows Surface Xbox ã‚»ãƒ¼ãƒ« ã‚µãƒãƒ¼ãƒˆ ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ Windows ã‚¢ãƒ—ãƒª OneDrive Outlook Skype OneNote Microsoft Teams PC ã¨ãƒ‡ãƒã‚¤ã‚¹ Xbox ã‚’è³¼å…¥ã™ã‚‹ ã‚¢ã‚¯ã‚»ã‚µãƒª VR & è¤‡åˆç¾å®Ÿ ã‚¨ãƒ³ã‚¿ãƒ¡ Xbox Game Pass Ultimate Xbox Live Gold Xbox ã¨ã‚²ãƒ¼ãƒ PC ã‚²ãƒ¼ãƒ Windows ã‚²ãƒ¼ãƒ æ˜ ç”»ã¨ãƒ†ãƒ¬ãƒ“ç•ªçµ„ æ³•äººå‘ã‘ Microsoft Azure Microsoft Dynamics 365 Microsoft 365 Microsoft Industry ãƒ‡ãƒ¼ã‚¿ ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ Power Platform æ³•äººå‘ã‘ã‚’è³¼å…¥ã™ã‚‹ Developer & IT .NET Visual Studio
hiroponz 2009/12/28
*programming

tips

sql
ãƒªãƒ³ã‚¯
ã€ŒSQL CLRã€SQL-Server 2008 Expressã®é–¢æ•°ã‚’C#è¨€èªžã§ä½œã‚‹!!
ã“ã®ãƒ–ãƒã‚°ã‚’è¦‹ã¦ä¸‹ã•ã£ãŸçš†æ§˜ã«ã€å¿ƒã‚ˆã‚Šæ„Ÿè¬ç”³ã—ä¸Šã’ã¾ã™ã€‚åå‰ã¯ã‚²ãƒ¼ãƒ ãƒ–ãƒã‚°ã§ã™ãŒã€è‰²ã€…ãªè©±é¡Œã‚’æ›¸ã‹ã›ã¦é ‚ããŸã„ã¨æ€ã„ã¾ã™(å¤§å¥½ããªå†™çœŸ/æ˜ åƒ/ã‚«ãƒ¡ãƒ©ã€ãƒšãƒ³ã€ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã€é£Ÿã¹ç‰©ã€æ˜ ç”»ã€ã‚¯ãƒ«ãƒžã€å®¶é›»è£½å“ãªã©ãªã©)ã€‚ ãªã«ã¨ãžã€ã“ã‚Œã‹ã‚‰ã‚‚ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚çš†æ§˜ã‚ã£ã¦ã®ãƒ–ãƒã‚°ã§ã™ã€‚ ä»Šå›žã®è¨˜äº‹ã¯ã€SQL-Server 2008 Expressã®é–¢æ•°ã‚’ã€C#è¨€èªžã§ä½œã‚‹æ–¹æ³•ã«ã¤ã„ã¦æ›¸ã‹ã›ã¦é ‚ãã¾ã™ã€‚ SQL-Serverã¯ã€SQL-Server 2000ã®æ™‚ä»£ã‹ã‚‰é–¢æ•°ã‚’ä½œã‚‹äº‹ãŒå‡ºæ¥ã‚‹ã®ã§ã™ãŒã€ãã‚Œã¯ã€ã‚ãã¾ã§ã‚‚SQL(Microsoft Transact SQL)ã®ç¯„å›²å†…ã§ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ æœ¬æ¥ãªã‚‰ã°ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹ãŸã‚ã®è¨€èªžã§ã‚ã‚‹SQLã§ã™ã‹ã‚‰ã€é€šå¸¸ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã¨åŒç‰ã®å‡¦ç†ã‚’çµ„ã¿ä¸Šã’ã‚‹ã®ã¯ç‹¬ç‰¹ã®è‹¦åŠ´ãŒã‚ã‚Šã¾ã™ã—ã€ä¸€è¡Œã”ã¨ã«å€¤ã‚’è¿”ã™ã‚¹ã‚«ãƒ©åž‹é–¢æ•°ã‚’ä½¿ã†å ´åˆã¯ã€ãƒ‘
hiroponz 2009/12/28
*programming

sql

clr

C#

tips
ãƒªãƒ³ã‚¯
Webä¸Šã§è¦‹ã‚„ã™ã„SQLã«æ•´å½¢ã™ã‚‹Â·SQLæ•´å½¢ãƒ„ãƒ¼ãƒ« DML Breaker MOONGIFT
SQLæ•´å½¢ãƒ„ãƒ¼ãƒ« DML Breakerã¯JavaScriptè£½ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€‚O/Rãƒžãƒƒãƒ”ãƒ³ã‚°ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯æ•°å¤šãç™»å ´ã—ã¦ã„ã‚‹ãŒã€ã‚ˆã‚Šç´°ã‹ãªæœ€é©åŒ–ã‚’æ±‚ã‚ãŸã‚Šã€æ—§æ¥ã®ã‚·ã‚¹ãƒ†ãƒ ã§ã¯ã¾ã ã¾ã SQLã‚’ä½¿ã‚ã–ã‚‹ã‚’å¾—ãªã„å ´é¢ãŒå¤šã„ã€‚ã¾ãŸãƒã‚°ã«åãå‡ºã•ã‚ŒãŸSQLã‚’ãƒã‚§ãƒƒã‚¯ã—ãŸã‚Šã™ã‚‹å¿…è¦ãŒã‚ã‚‹å ´é¢ã¯å¤šã€…ã‚ã‚‹ã€‚ WHEREã§ã¤ãªã„ã ç‰ˆ ãã‚“ãªæ™‚ã«å‡ºåŠ›ã•ã‚ŒãŸSQLã‚’æ‰‹ä½œæ¥ã§ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å˜ä½ã«åˆ†ã‘ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«åã‚’ä¸¦ã¹ãŸã‚Šã™ã‚‹ã®ã¯æ‰‹é–“ã®ã‹ã‹ã‚‹ä½œæ¥ã ã€‚ãã“ã§ä½¿ã£ã¦ã¿ãŸã„ã®ãŒSQLæ•´å½¢ãƒ„ãƒ¼ãƒ« DML Breakerã«ãªã‚‹ã€‚ã“ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯è²¼ä»˜ã‘ãŸSQLã‚’è§£æžã—ã¦èªã¿ã‚„ã™ã„SQLã«å¤‰æ›ã—ã¦ãã‚Œã‚‹ã®ã ã€‚ CRUDï¼ˆSELECT/INSERT/UPDATE/DELETEï¼‰ã®SQLã«å¯¾å¿œã—ã¦ãŠã‚Šã€é©åˆ‡ãªæ”¹è¡Œã‚„ã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆã‚’æŒ¿å…¥ã—ã¦ãã‚Œã‚‹ã€‚Webãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã§å‹•ä½œã™ã‚‹ã®ã§ç¤¾å†…ã«ä¸€ã¤ã§ã‚ã‚Œã°çš†ã§ä½¿ãˆã¦ä¾¿åˆ©ã ã‚ã†ã€‚
hiroponz 2009/11/13
*tool

sql

Apache
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
hiroponz 2009/01/26
*tool

sql

ER diagram

web

service
ãƒªãƒ³ã‚¯
A5:SQL Mk-2 - ãƒ•ãƒªãƒ¼ã®æ±Žç”¨SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«/ERå›³ãƒ„ãƒ¼ãƒ«
A5:SQL Mk-2ã¯è¤‡é›‘åŒ–ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã‚’æ”¯æ´ã™ã‚‹ãŸã‚ã«é–‹ç™ºã•ã‚ŒãŸãƒ•ãƒªãƒ¼ã®SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ é«˜æ©Ÿèƒ½ã‹ã¤è»½é‡ã§ã€ä½¿ã„æ–¹ãŒåˆ†ã‹ã‚Šã‚„ã™ã„ã“ã¨ã‚’ç›®æ¨™ã«é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ SQLã‚’å®Ÿè¡Œã—ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç·¨é›†ã™ã‚‹ã»ã‹ã«ã€SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã—ãŸã‚Šã€ERå›³ã‚’ä½œæˆã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ç‰¹å¾´ãƒ»æ©Ÿèƒ½ OCIæŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãƒ»ADOã¾ãŸã¯ODBCã‚’ä»‹ã—ãŸDBã¸ã®æŽ¥ç¶š Oracle Databaseã¯OCIçµŒç”±ã®æŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ PostgreSQLã¨MySQLã¯ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ Microsoft SQL Serverã¯ã€OLE DBãƒ—ãƒãƒã‚¤ãƒ€ã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ IBM DB2ã¯ã€ODBCãƒ‰ãƒ©ã‚¤ãƒã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ ãã®ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ADOã¾ãŸã¯ODBCã‚’åˆ©ç”¨ã—ã¦æŽ¥ç¶šã—ã¾ã™ã€‚ Oracle, PostgreSQL, MySQLã¯ã€A5:SQL
hiroponz 2008/12/02
*tool

sql

development

ER diagram

windows

db

later
ãƒªãƒ³ã‚¯
ã€ŒSQLã€ã«é–¢ã™ã‚‹è¨˜äº‹ä¸€è¦§
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
hiroponz 2008/10/31
SQLã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã„ã‚ã„ã‚ã€‚

*programming

sql

technique

later
ãƒªãƒ³ã‚¯
ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ : æ—¥çµŒé›»åç‰ˆ
éºä¼åã‚’åŠ¹çŽ‡ã‚ˆãæ”¹å¤‰ã™ã‚‹ã‚²ãƒŽãƒ ç·¨é›†ç ”ç©¶ã®ç¬¬ä¸€äººè€…ã§ç±³ãƒ–ãƒãƒ¼ãƒ‰ç ”ç©¶æ‰€ã®ãƒ•ã‚§ãƒ³ãƒ»ãƒãƒ£ãƒ³ä¸»ä»»ç ”ç©¶å“¡ã¯ã€ã‚¨ãƒœãƒ©å‡ºè¡€ç†±ã‚„ã‚¸ã‚«ç†±ã®æ—©æœŸè¨ºæ–æŠ€è¡“ã‚’é–‹ç™ºã—ãŸã“ã¨ã‚’æ˜Žã‚‰ã‹ã«ã—ãŸã€‚ã‚¦ã‚¤ãƒ«ã‚¹ã®éºä¼æƒ…å ±ãŒâ€¦ç¶šã å—ç²¾åµã®ã‚²ãƒŽãƒ ç·¨é›†ã€ãªãœå•é¡Œã€€å„ªç”Ÿæ€æƒ³ã¨è¡¨è£ä¸€ä½“ ï¼»æœ‰æ–™ä¼šå“¡é™å®šï¼½ ã‚²ãƒŽãƒ ç·¨é›†é£Ÿå“ã€€è²©å£²å®¹èªã€æ¡ä»¶æº€ãŸã›ã°å®‰å…¨å¯©æŸ»ãªã— ï¼»æœ‰æ–™ä¼šå“¡é™å®šï¼½
hiroponz 2008/10/29
*web

security

sql
ãƒªãƒ³ã‚¯
404 Blog Not Found:æ›¸è©•x3 - SQLæœ¬ä¸‰å¤§å¯¾æ±º
2008å¹´02æœˆ03æ—¥04:00 ã‚«ãƒ†ã‚´ãƒªæ›¸è©•/ç”»è©•/å“è©•Lightweight Languages æ›¸è©•x3 - SQL æœ¬ä¸‰å¤§å¯¾æ±º 404 Blog Not Found:ã“ã®ç™ºæƒ³ã¯ãªã‹ã£ãŸ - æ›¸è©• - é€†ç®—å¼SQLæ•™ç§‘æ›¸ã‚’æ›¸ã„ãŸã‚‰ã€ã€Œã„ã‚„ã€ã†ã¡ã‚‚ã€ã¨ã°ã‹ã‚Šã«ã©ã£ã•ã‚ŠSQL æœ¬ãŒæ¥ãŸã€‚ ã¾ãšã‚ªãƒ©ã‚¤ãƒªãƒ¼ãƒ»ã‚¸ãƒ£ãƒ‘ãƒ³ã®çŸ¢é‡Žæ§˜ã‹ã‚‰ã¯ã€ã€ŒSTATISTICS HACKS(å’Œè¨³)ã€ã¨ä¸€ç·’ã«ã€ŒSQLã‚¯ãƒƒã‚¯ãƒ–ãƒƒã‚¯ã€ã¨ã€ŒSQL Hacks ã€ã‚’ã€ãã—ã¦C&Rç ”ç©¶æ‰€ã®å‰æˆæ§˜ã‹ã‚‰ã¯ã€ŒSQLå®Ÿè·µæ´»ç”¨å¤§äº‹å…¸ ã€ã‚’çŒ®æœ¬ã„ãŸã ã„ãŸã€‚ ã“ã‚Œã ã‘é ‚ãã¨ã€ã¾ã¨ã‚ãªã„ã‚ã‘ã«ã¯è¡Œã‹ãªã„ã ã‚ã†ã¨ã„ã†ã“ã¨ã§ã€ã¾ã¨ã‚ã¦ã¿ãŸã€‚ ã¾ãšã€ã€ŒSQLã‚¯ãƒƒã‚¯ãƒ–ãƒƒã‚¯ã€ã€‚ã“ã¡ã‚‰ã¯ç”³ã—è¨³ãªã„ã®ã ã‘ã©ã€ã‹ãªã‚ŠæœŸå¾…ã¯ãšã‚Œã€‚ç¢ºã‹ã«ã€Œé€†ç®—å¼SQLæ•™ç§‘æ›¸ã€ã‚ˆã‚Šã¯ç”¨ä¾‹ã‚‚å¤šã‹ã£ãŸã®ã ã‘ã©ã€Cookbookã‚’ç‰¹å¾´ã¥ã‘ã¦ã„ãŸç¶¿å¯†ãªDiscussionãŒã‚¹ã‚«ã‚¹ã‚«ã€‚ä»–ãªã‚‰ã¨
hiroponz 2008/02/05
SQLã®å‹‰å¼·ã«å½¹ç«‹ã¤æœ¬

*DB

sql

book
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
hiroponz 2007/07/11
éžå¸¸ã«ãŸã‚ã«ãªã‚‹DBé–¢é€£ã®è©±

*tips

db

sql

study

later
ãƒªãƒ³ã‚¯
MOONGIFT: Â» SQLiteã‚’GUIã§ç®¡ç†ã€ŒSQLite Database Browserã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
SQLiteã¯DLLãƒ•ã‚¡ã‚¤ãƒ«ã ã‘ã§ã™ãã«åˆ©ç”¨ã§ãã‚‹ç°¡æ˜“çš„ãªDBã§ã¯ã‚ã‚‹ãŒã€æ€ã£ã¦ã„ã‚‹ã‚ˆã‚Šã‚‚ã—ã£ã‹ã‚Šã¨å‹•ä½œã—ã¦ãã‚Œã‚‹ã€‚ ä»–ã®DBã®ã‚ˆã†ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚‚æ‰‹é–“ã‚‚ãªãã™ãã«åˆ©ç”¨ã§ãã‚‹ã®ãŒä¾¿åˆ©ã ã€‚æœ€è¿‘ã¯PHP5ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒã‚‚å¢—ãˆãŸã®ã§ã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¢ãƒƒãƒ—ã™ã‚‹ã ã‘ã§ã™ãã«åˆ©ç”¨ã§ãã‚‹ã¨ã„ã†ã®ã‚‚æ‰‹è»½ã§ã„ã„ã€‚ ãã‚“ãªSQLiteã§ã‚ã‚‹ãŒã€ç®¡ç†ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã¯æ¨™æº–ã§ã¯ç”¨æ„ã•ã‚Œã¦ã„ãªã„ã€‚æ™®åŠã®ãŸã‚ã«ã¯é«˜æ©Ÿèƒ½ã€ã‹ã¤æ‰‹è»½ãªç®¡ç†ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã®å˜åœ¨ã¯æ¬ ã‹ã›ãªã„ã ã‚ã†ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯SQLite Database Browserã€SQLiteã‚’GUIã§æ“ä½œã§ãã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ SQLite Database Browserã‚’ä½¿ã†ã¨ã€GUIãƒ™ãƒ¼ã‚¹ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆã¯ã‚‚ã¡ã‚ã‚“ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¨è¨ˆã‚„ãƒ‡ãƒ¼ã‚¿ã®ç·¨é›†ãŒã§ãã‚‹ã€‚SQLã‚’å®Ÿè¡Œã—ã¦çµæžœã‚’è¦‹ã‚‹ã“ã¨ã‚‚å¯èƒ½ã ã€‚ã‚‚ã¡ã‚ã‚“ã€æ—¥æœ¬èªžã«å¯¾å¿œ
hiroponz 2007/07/10
SQLiteã®ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰

*programming

sql

tool
ãƒªãƒ³ã‚¯
çª“ã®æœ - ã€NEWSã€‘SQLæ–‡ã‚’GUIã§ä½œæˆã§ãã‚‹ãƒ•ãƒªãƒ¼ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒã€Œé»’çŒ« SQL Studioã€
GUIã«ã‚ˆã‚‹SQLæ–‡ã®ä½œæˆãªã©ã€ã•ã¾ã–ã¾ãªé–‹ç™ºæ”¯æ´æ©Ÿèƒ½ã‚’å‚™ãˆã‚‹SQLé–‹ç™ºç’°å¢ƒã€Œé»’çŒ« SQL Studioã€v1.1.7.413ãŒ6æœˆ4æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã€‚Windows 2000/XPã«å¯¾å¿œã—ã¦ãŠã‚Šã€å€‹äººä½¿ç”¨ãƒ»æ¥å‹™ã«ã‹ã‹ã‚ã‚‰ãšãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã¨ã—ã¦åˆ©ç”¨å¯èƒ½ã€‚ç¾åœ¨ä½œè€…ã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚ ã€Œé»’çŒ« SQL Studioã€ã¯ã€SQLæ–‡ã®ä½œæˆã‚„ãƒ†ã‚¹ãƒˆã‚’è¡Œãˆã‚‹æ±Žç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒã€‚æœ¬ã‚½ãƒ•ãƒˆä¸Šã‹ã‚‰OLE DBæŽ¥ç¶šã¾ãŸã¯ODBCãƒ‰ãƒ©ã‚¤ãƒã«å¯¾å¿œã™ã‚‹å„ç¨®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ç›´æŽ¥æŽ¥ç¶šå¯èƒ½ã§ã€ä½œæˆã—ãŸSQLæ–‡ã‚’å®Ÿéš›ã«ãƒ†ã‚¹ãƒˆå®Ÿè¡Œã§ãã‚‹ã€‚ç”»é¢ã¯3ãƒšã‚¤ãƒ³æ§‹æˆã§ã€å·¦å´ã«ã¯è¤‡æ•°ã®SQLã‚½ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç®¡ç†ã§ãã‚‹ãƒ•ã‚¡ã‚¤ãƒ©ãƒ¼ã€ä¸å¤®ã«ã¯è¤‡æ•°ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¿ãƒ–ã§åˆ‡ã‚Šæ›¿ãˆã¦è¡¨ç¤ºã§ãã‚‹ã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ã€å³å´ã«ã¯æŽ¥ç¶šã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹é€ ã‚’ãƒ„ãƒªãƒ¼ã¨ãƒªã‚¹ãƒˆã§è¡¨ç¤ºã™ã‚‹â€œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¼ãƒ©â€ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚ SQLæ–‡ã®ä½œæˆæ™‚ã¯ã€ã•ã¾ã–
hiroponz 2007/07/06
SQLã®ç·¨é›†ã«å½¹ç«‹ã¤ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆ

*programming

sql

tool
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸