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

amari3 id:amari3

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

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

ãƒ•ãƒ«ãƒ†ã‚ã‚¹ãƒˆã‚’ä½¿ç”¨ã™ã‚‹å ´åˆã®è€ƒæ…®äº‹é … - SQL Server
ã“ã®è¨˜äº‹ã§ã¯ã€æ—¥æœ¬èªžã® SQL Server ãƒ•ãƒ«ãƒ†ã‚ã‚¹ãƒˆæ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ç”¨ã™ã‚‹å ´åˆã«é©ç”¨ã•ã‚Œã‚‹è€ƒæ…®äº‹é …ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ é©ç”¨å¯¾è±¡: SQL Server å…ƒã® KB ç•ªå·: 2252955 ã¯ã˜ã‚ã« æ—¥æœ¬èªžã§ã¯ã€èªžå¥ã¯ã€ãã‚Œã‚‰ã®å˜èªžã®é–“ã«ã‚¹ãƒšãƒ¼ã‚¹ã‚’å«ã¾ãªã„ 2 ã¤ä»¥ä¸Šã®å˜èªžã§æ§‹æˆã•ã‚Œã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ Microsoft SQL Server ã§ã¯ã€SQL Server ãƒ•ãƒ«ãƒ†ã‚ã‚¹ãƒˆæ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ç”¨ã—ã¦æ—¥æœ¬èªžèªžå¥ã®ãƒ—ãƒ¬ãƒ•ã‚£ãƒƒã‚¯ã‚¹æ¤œç´¢ã‚’å®Ÿè¡Œã™ã‚‹å ´åˆã€ãƒ•ãƒ«ãƒ†ã‚ã‚¹ãƒˆæ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã§ã¯ã€èªžå¥ãŒãƒ—ãƒ¬ãƒ•ã‚£ãƒƒã‚¯ã‚¹ç”¨èªžã¨ã¯è¦‹ãªã•ã‚Œã¾ã›ã‚“ã€‚ ä»£ã‚ã‚Šã«ã€ãƒ•ãƒ«ãƒ†ã‚ã‚¹ãƒˆæ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã¯èªžå¥ã‚’å˜èªžç”¨èªžã¨è¦‹ãªã—ã¾ã™ã€‚ ã“ã‚Œã¯ã€å˜èªžãŒã‚¹ãƒšãƒ¼ã‚¹ã‚„å¥èªç‚¹ã®ãªã„æ–‡å—ã®æ–‡å—åˆ—ã¨ã—ã¦å®šç¾©ã•ã‚Œã¦ã„ã‚‹ãŸã‚ã§ã™ã€‚ ã•ã‚‰ã«ã€æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã¯ãƒ—ãƒ¬ãƒ•ã‚£ãƒƒã‚¯ã‚¹ä¸€è‡´ãƒ¢ãƒ¼ãƒ‰ã§ã®ã¿æ©Ÿèƒ½ã—ã¾ã™ã€‚ æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã¯ã€ã‚µãƒ•ã‚£ãƒƒã‚¯ã‚¹ä¸€è‡´ãƒ¢ãƒ¼ãƒ‰ã§ã¯æ©Ÿèƒ½ã—ã¾ã›
amari3 2015/01/26
sqlserver
ãƒªãƒ³ã‚¯
å…¨ã¦ã¯æ™‚ã®ä¸ã«â€¦ : ã€SQL Serverã€‘ãƒ•ãƒ«ãƒ†ã‚ã‚¹ãƒˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹
2007/8/920:5 ã€SQL Serverã€‘ãƒ•ãƒ«ãƒ†ã‚ã‚¹ãƒˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹ ãƒ•ãƒ«ãƒ†ã‚ã‚¹ãƒˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã€ãƒ†ã‚ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã«å¯¾ã™ã‚‹å…¨æ–‡æ¤œç´¢ã‚’é«˜é€Ÿã§è¡Œã†ãŸã‚ã®ä»•çµ„ã¿ã§ã‚ã‚‹ã€‚ é€šå¸¸ã¯ã€Likeæ¼”ç®—åã‚’ä½¿ã£ã¦æ¤œç´¢ã™ã‚‹ãŒã€ã“ã®æ–¹æ³•ã§çµæžœã‚’å¾—ãŸå ´åˆã«ãƒ‡ãƒ¼ã‚¿é‡ã«ã‚ˆã£ã¦ã¯ã€æ•°åˆ†ç¨‹åº¦ã®æ¤œç´¢æ™‚é–“ã«ãªã‚‹ã“ã¨ãŒã‚ã‚‹ã€‚ ã“ã®ãƒ•ãƒ«ãƒ†ã‚ã‚¹ãƒˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ãŸãƒ‡ãƒ¼ã‚¿æŠ½å‡ºæ–¹æ³•ï¼ˆSELECTæ–‡ï¼‰ã«ã¤ã„ã¦èª¬æ˜Žã™ã‚‹ã€‚ ãƒ•ãƒ«ãƒ†ã‚ã‚¹ãƒˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®å ´åˆã€CONTAINSã‚’ä½¿ç”¨ã—ã¦æ–‡å—åˆ—æ¤œç´¢ã‚’è¡Œã†ã€‚ ä»¥ä¸‹ã€æ§‹æ–‡ã€‚ --ãƒ•ãƒ«ãƒ†ã‚ã‚¹ãƒˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ã‚«ã‚¿ãƒã‚°ä½œæˆ USE ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å CREATE FULLTEXT CATALOG ã‚«ã‚¿ãƒã‚°å ON FILEGROUP SECONDARY --ãƒ•ãƒ«ãƒ†ã‚ã‚¹ãƒˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œæˆ CREATE FULLTEXT INDEX ON ãƒ†ãƒ¼ãƒ–ãƒ«å(é …ç›®å) KEY INDEX PL_ãƒ†ãƒ¼ãƒ–ãƒ«
amari3 2015/01/26
sqlserver
ãƒªãƒ³ã‚¯
å¤§æ–‡å—å°æ–‡å—åŒºåˆ¥ã™ã‚‹ï¼³ï¼±ï¼¬ï¼ˆSQLServerï¼‰
ä»Šã•ã‚‰ã§ã™ãŒãƒ»ãƒ»ãƒ»é€šå¸¸å¤§æ–‡å—ã¨å°æ–‡å—ã‚’åŒºåˆ¥ã™ã‚‹ã‹ã©ã†ã‹ã¯SQLserverã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã«æ±ºå®šã•ã‚Œã‚‹ãŒã€ ã‚‚ã—åŒºåˆ¥ã—ãªã„å½¢å¼ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã—ã¾ã£ãŸå ´åˆã¯ã€COLLATEå¥ã‚’ä»˜ã‘ã¦SQLæ–‡ã‚’è¨˜è¿°ã™ã‚‹ã¨ã‚ˆã„ã€‚ SELECT * FROM testTB WHERE name = 'STDMAN' COLLATE Japanese_CS_AS_KS_WS ãƒ»CIã€€å¤§æ–‡å—ã€å°æ–‡å—ã‚’åŒºåˆ¥ã—ãªã„ã€‚å…¨è§’ã‚¢ãƒ«ãƒ•ã‚¡ãƒ™ãƒƒãƒˆã®å¤§æ–‡å—ã€å°æ–‡å—ã‚‚åŒºåˆ¥ã—ãªã„ ãƒ»CSã€€å¤§æ–‡å—ã€å°æ–‡å—ã‚’åŒºåˆ¥ã™ã‚‹ã€‚å…¨è§’ã‚¢ãƒ«ãƒ•ã‚¡ãƒ™ãƒƒãƒˆã®å¤§æ–‡å—ã€å°æ–‡å—ã‚‚åŒºåˆ¥ã™ã‚‹ ãƒ»AIã€€ã‚¢ã‚¯ã‚»ãƒ³ãƒˆã€æ¿éŸ³ã€ç ´è£‚éŸ³ã‚’åŒºåˆ¥ã—ãªã„ã€‚ ãƒ»ASã€€ã‚¢ã‚¯ã‚»ãƒ³ãƒˆã€æ¿éŸ³ã€ç ´è£‚éŸ³ã‚’åŒºåˆ¥ã™ã‚‹ã€‚ ãƒ»KSã€€ã²ã‚‰ãŒãªã¨ã‚«ã‚¿ã‚«ãƒŠã‚’åŒºåˆ¥ã™ã‚‹ã€‚åŠè§’ã§ã‚‚åŒºåˆ¥ã™ã‚‹ ãƒ»WSã€€æ–‡å—å¹…ã‚’åŒºåˆ¥ã™ã‚‹ã€‚ï¼ˆå…¨è§’åŠè§’ã‚’åŒºåˆ¥ã™ã‚‹ï¼‰ è©³ã—ãã¯SQLServeré–‹ç™ºãƒãƒ¼ãƒ ã®ãƒ–ãƒã‚°(2008/06/16)ã‚’å‚è€ƒã«ã—ã¦
amari3 2015/01/22
sqlserver
ãƒªãƒ³ã‚¯
OFFSET FETCH ã®ç´¹ä»‹ - ãŠ ã ã®ã‚¹ãƒšãƒ¼ã‚¹
OFFSET FETCH ã¯ SQL Server 2012 ã‹ã‚‰è¿½åŠ ã•ã‚Œã¾ã—ãŸã€‚ ORDER BY å¥ (Transact-SQL) ã‚¯ã‚¨ãƒªã®çµæžœã‚’è¿”ã™è¡Œæ•°ã‚’åˆ¶é™ã™ã‚‹ãŸã‚ã«ä½¿ç”¨ã—ã¾ã™ã€‚ä¸»ã«ãƒšãƒ¼ã‚¸ãƒ³ã‚°å‡¦ç†ã¨ã‹ã§ä½¿ã‚ã‚Œã‚‹ã¨æ€ã„ã¾ã™ã€‚ 2008 R2 ã¾ã§ã¯ãƒšãƒ¼ã‚¸ãƒ³ã‚°å‡¦ç†ã‚’è¡ŒãŠã†ã¨ã™ã‚‹ã¨ã€ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚’ä½¿ã†å¿…è¦ãŒã‚ã‚Šã¾ã—ãŸã€‚ ã“ã‚“ãªãƒ‡ãƒ¼ã‚¿ãŒã‚ã£ãŸæ™‚ã«ã€ -- æº–å‚™ CREATE TABLE [å—æ³¨] ( [Id] [int] identity(1,1) not null primary key, [å—æ³¨ç•ªå·] [nvarchar](10) not null, [å—æ³¨æ—¥] [date] not null, [é‡‘é¡] [int] not null ) go insert into [å—æ³¨] values ('J01', '2013/02/02', 1200), ('J02', '2013/02/05
amari3 2015/01/08
sqlserver
ãƒªãƒ³ã‚¯
SQL Server ã§ MySQL ã® LIMIT å¥ç›¸å½“ã®å‡¦ç† - katz's adversaria
MySQL ã§ã¯æŒ‡å®šã—ãŸä»¶æ•°ã®ã¿å–å¾—ã—ãŸã„å ´åˆã€LIMIT å¥ã‚’ä½¿ç”¨ã™ã‚‹ã€‚ SELECT col_name FROM tbl_name WHERE condition ORDER BY order_rule LIMIT offset,row_count SQL Server ã«ã¯ LIMIT å¥ãŒå˜åœ¨ã—ãªã„ã®ã§ã€åŒã˜çµæžœã‚’å–å¾—ã—ãŸã„å ´åˆã¯ ROW_NUMBER() ã‚’ç”¨ã„ã‚‹ã€‚ SELECT col_name FROM (SELECT ROW_NUMBER() OVER(ORDER BY order_rule) AS rownum,* FROM tbl_name WHERE condition) AS tbl WHERE rownum BETWEEN offset+1 AND offset+row_count ORDER BY rownum offset ãŒãªã„å ´åˆã¯ TOP ã‚’ä½¿ãˆã°ã‚ˆã„ã€‚
amari3 2015/01/08
sqlserver
ãƒªãƒ³ã‚¯
PHPã‹ã‚‰SQL Serverã«æŽ¥ç¶šã—ã¦ã¿ã‚‹ - chorus log
ä»¥ä¸‹ã®ç’°å¢ƒã§ã€PHPã‹ã‚‰SQL Serverã«æŽ¥ç¶šã™ã‚‹æ‰‹é †ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ Windows 7 SP1(x64) IIS7ï¼ˆ*ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ¸ˆã¿ï¼‰ SQL Server 2008 R2 SP1ï¼ˆ*ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ¸ˆã¿ï¼‰ PHP 5.4 (5.4.3)ï¼ˆ*ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ¸ˆã¿ æ‰‹é †ã¯ã“ã¡ã‚‰ï¼‰ ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã®å–å¾— ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã‚µã‚¤ãƒˆã‹ã‚‰ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¾ã™ã€‚SQLSRV30.EXEã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¾ã™ã€‚SQLSRV30.EXEã ã¨SQL Server 2012 ã«å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚ ä½¿ç”¨è¨±è«¾ã«åŒæ„ã—ã¾ã™ã€‚ è§£å‡å…ˆã‚’æŒ‡å®šã—ã¾ã™ã€‚ ä½¿ã£ã¦ãã‚Œã¦ã‚ã‚ŠãŒã¨ã†ã€è©³ã—ãã¯chmãƒ˜ãƒ«ãƒ—èªã‚“ã§ãçš„ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã®ã§OKã‚’æŠ¼ã—ã¦é–‰ã˜ã¾ã™ã€‚ è§£å‡å…ˆã«dllãƒ•ã‚¡ã‚¤ãƒ«ãŒä½œæˆã•ã‚Œã¦ã„ã¾ã™ã€‚ PHPã®æ‹¡å¼µè¨å®š PHPã§SQLiteã®æ‹¡å¼µæ©Ÿèƒ½ã‚’æœ‰åŠ¹åŒ–ã—ã¾ã™ã€‚php.iniãƒ•ã‚¡ã‚¤ãƒ«ï¼ˆä¾‹ï¼š"C:\php\php.ini"ï¼‰ã‚’
amari3 2015/01/06
php

sqlserver
ãƒªãƒ³ã‚¯
ã€ŒMicrosoft Drivers for PHP for SQL Serverã€ã®v2.0ã¨v3.0
å‰ç½®ãã“ã‚“ã°ã‚“ã¯ã€‚ï¼“ã‹æœˆã¶ã‚Šã®ã‚¨ãƒ³ãƒˆãƒªã§ã™ã€‚ è¡¨é¡Œã®ã¨ãŠã‚Šã€ä»Šå›žã®ãƒã‚¿ã¯ PHP ã¨ Microsoft ãª Windows é™å®šã®ãŠè©±ã§ã™ã€‚ çš†ã•ã‚“ã¯ã€ŒMicrosoft Drivers for PHP for SQL Serverã€ã¨ã„ã†ã®ã‚’ã”å˜ã˜ã§ã—ã‚‡ã†ã‹ã€‚ PHPã‹ã‚‰Microsoft SQL Serverã«æŽ¥ç¶šã™ã‚‹ãŸã‚ã®MicrosoftãŒæä¾›ã™ã‚‹ãƒ‰ãƒ©ã‚¤ãƒã§ã™ã€‚ . ã€ŒMicrosoft Drivers 2.0 for PHP for SQL Serverã€ã‹ã‚‰PDOã«å¯¾å¿œã—ã¦ã„ã‚‹ã®ã§ã€ä½¿ã„ã‚„ã™ããªã‚Šã¾ã—ãŸã€‚ å½“æ™‚ã®MSã®ä¸ã®äººãŒæ›¸ã„ãŸè¨˜äº‹ã«ã¯æœŸå¾…ã‚ãµã‚Œã‚‹å†…å®¹ãŒæ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ (å‚è€ƒ) CodeZine PHPã‹ã‚‰Microsoft SQL Serverã‚’ä½¿ãŠã†ï¼ ç¬¬2å›ž PHPã‹ã‚‰SQL Serverã¸ã®æ£ã—ã„æŽ¥ç¶šæ–¹æ³• (2011/02/08) ã§ã™ãŒã€ã€Œå€¤ã¯UTF-8ã«å¤‰æ›
amari3 2015/01/06
php

sqlserver
ãƒªãƒ³ã‚¯
Windows + IIS + php5.4ç³» + SQL server ã®è¨å®š at softelãƒ¡ãƒ¢
å•é¡Œ ä»¥ä¸‹ã®ç’°å¢ƒã‚’æ§‹ç¯‰ã›ã‚ˆã€‚ OSã¯Windowsã€‚Webã‚µãƒ¼ãƒãƒ¼ã¯IISã€‚phpã§ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯5.4ç³»ã€‚SQL serverã‚’ä½¿ã†ã€‚ + + + ç”ãˆ Windows7ã§ã€IIS7 + php5.4.0 ã§ã€SQLServerã§ãã‚‹ç’°å¢ƒã‚’ä½œã‚‹ã€‚ IISã¯æ©Ÿèƒ½ã®æœ‰åŠ¹åŒ–ã§OKã€‚ ã‚„ã‚„ã“ã—ã„ã®ã¯ã€php5.4ã§SQLServerã«æŽ¥ç¶šã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã¨ã“ã‚ã ã¨æ€ã†ã€‚ â— php5.4ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ http://windows.php.net/download/ VC9 x86 Non Thread Safe ã®Zipã®ã§ã‚ˆã„ã€‚ â— phpç”¨ãƒ‰ãƒ©ã‚¤ãƒã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ Microsoft Drivers 3.0 for SQL Server for PHP http://www.microsoft.com/download/en/details.aspx?id=20098 SQLSRV30.EXE
amari3 2015/01/06
php

sqlserver
ãƒªãƒ³ã‚¯
PHPã‹ã‚‰SQL Serverã¸ã®æ£ã—ã„æŽ¥ç¶šæ–¹æ³•
ã¯ã˜ã‚ã« å‰å›žã‹ã‚‰ã‚·ãƒªãƒ¼ã‚ºã§ãŠé€ã‚Šã—ã¦ã„ã‚‹ã€ŒPHPã‹ã‚‰Microsoft SQL Serverã‚’ä½¿ãŠã†ï¼ã€ã€ç¬¬2å›žç›®ã¯ã€PHPã‚³ãƒ¼ãƒ‰ã‹ã‚‰ã®Microsoft SQL Serverï¼ˆä»¥ä¸‹ SQL Serverï¼‰ã¸ã®æŽ¥ç¶šã«ã¤ã„ã¦ã§ã™ã€‚ ä»Šå›žã®è¨˜äº‹ã§ã¯ã€ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆãŒPHPå‘ã‘ã«ãƒªãƒªãƒ¼ã‚¹ã—ãŸã€SQL Server Driver for PHPãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã®å…¥æ‰‹ã¨ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€å®Ÿéš›ã«PHPã®ã‚³ãƒ¼ãƒ‰ã‹ã‚‰SQL Serverã«æŽ¥ç¶šã™ã‚‹ãŸã‚ã®æ–¹æ³•ã«ã¤ã„ã¦ç´¹ä»‹ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ 1 PHPã‚³ãƒ¼ãƒ‰ã‹ã‚‰SQL Serverã¸ã®æŽ¥ç¶š 1.1 PHPã‚³ãƒ¼ãƒ‰ã‹ã‚‰SQL Serverã¸æŽ¥ç¶šã™ã‚‹ãŸã‚ã®æ‰‹æ®µ PHP 5.2ã¾ã§ã®PHPãƒ©ãƒ³ã‚¿ã‚¤ãƒ ã«ã¯ã€SQL Serverã«æŽ¥ç¶šã™ã‚‹ãŸã‚ã®Mssqlé–¢æ•°ï¼ˆphp_mssql.dllï¼‰ãŒç”¨æ„ã•ã‚Œã¦ãŠã‚Šã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã“ã‚Œã‚’ä½¿ç”¨ã—ã¦SQL Serverã«æŽ¥ç¶šã™ã‚‹ã“ã¨ãŒã§ãã¾
amari3 2015/01/06
php

sqlserver
ãƒªãƒ³ã‚¯
ä»Šæ›´ãªãŒã‚‰SQL Serverã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã¿ãŸ | foresta.me
amari3 2015/01/05
sqlserver
ãƒªãƒ³ã‚¯
1