SEΤҤȤꤴ

Ԥäꡢäꡢ¾ϱʤǤ̵˹ͤȡäȤȤ衣
ڽס֥εˤʤ»ˤĤݾڤޤ

2009ǯ05

SQL Server 2000 ξȹ1

γȯĶˤϡSQL Server 2000 4椢ޤ
ȤSQL¹ԤΤǤ41ΤSQL¹ԥ顼Ȥʤ롣

ΤΤʤSQLƱơ֥빽¤ƱʤΤˤä1顼ȤʤäƤޤ

Υ顼Ȥʤ륵С
ơ֥򻲾Ȥݤˡhogehoge.dbo.hogeTBLפȥեѥꤷƤ롣
ꥢʥ饤ǡǡ١hogehogeפȻꤷSQL¹Ԥȥ顼ȤϤʤʤmasterפȻꤷSQL¹Ԥȥ顼Ȥʤ롣

õȡɤ餽SQL ServerΡ֥СȹפطΤǤϤʤȤηã

4Τ3ϡJapanese_BINסĤ1ϡJapanese_CI_ASס

1ΡmasterפΥСȹϡJapanese_CI_ASסhogehogeפΥСȹϡJapanese_BINס
Ĥޤϡľܥǡ١hogehogeפꤹСJapanese_BINפȤʤ뤬masterפΤޤޤȡJapanese_CI_ASעJapanese_BINפȤʤΤǤ䤽줢㤻դ

ޤơޤ¾ΰƷǡä֤ǥƥȤƤ͡Զ礬ФʤäΡ

󡤤ޤSQLSELECTȤꡤǥ顼Ȥʤä櫓ĤޤϺޤǤä̵ääƤȤʤ͡

ִĶJapanese_BINפʤ麣Զȯʤ
ִĶޤǧ櫓ǤϤʤˡJapanese_CI_ASפä֤ϿĹ̤ʤФʤʤ
ִĶϡJapanese_BINפǤ¿

ǡ١masterפκƹۤ򤹤ɤ褦桼ä褦
ȡ¾ȤäƤ뤳ΥСȤʤʤ뤳Ȥ򤱤
ȤȤǡȤꤢξ줷ΤǤϤ뤱ɲˡ
Japanese_BINΥǡ١򿷵̾󤹤桼Υǥեȥǡ١򤽤οǡ١Ȥ롣
뤳ȤǡJapanese_BINJapanese_BINȾȹѹʤΤ̵ǽ롦Ȼפ

ôˤϡ֤ޤǤ⤽ξ줷ΤˡŪʲǤϤʤ׻Ƥ
κȤ夤顤СƹۤʡOS顣

Sessionѿ̵̸1

¸ץ򸵤˿ץäƤ櫓ǤϤ̡ȤǤʤ򤷤ƤǤ͡
Υȥˤ⤢ȤꡤSessionѿ̵̸Ǥ

ĢɼϤݡǡ١ǡФΥǡXMLƤΤǤʤȤXMLΥեǤϤʤSessionѿĤޤϥСΥŸƤΤǤ
ʤΤǥץबλ׷̵ä櫓ǡǥХå񤷤Ƥ롣
Sessionѿϡ³륯饤ꤵ櫓ǡ³륯饤ȿ¿¿ۤSessionѿ롣
饤ȤʤФۤɥС٤ȤϤʤʤɡɥ桼δĶWebС˳ƥ饤ü³ƺȤԤ櫓ǡ饤ü10ʾǤ
С¦åޥȤΥСǤɡѤǤˤ³ΤʤĤˤȤĤŤ˻פ
HDD˥եĢɼ¦ץɤ߹ȤФ褤Τ
Ƥˤ⤢뤱ɡ1ץ㤬3,000Ԥ⤢ʤư۾äïʤĤˤ褦ȷꤷΤäͤǾ򸫤Ƥߤ

ľɤϤ󥿡եݻޤ޹Ԥʤ

(911T)ޤ1

ʰѤƤSoftBank911Tޤ
Ÿʤʤޤơɤ褦⤢ޤ

ˤ⡤Ǥ˻ȤäƤVodafone֥ɤηäޤäƤΤǡUSIMɤؤȤƤޤ
(۵޻SoftBankdocomoϳڤǤ͡auUSIMؤǤϻȤȤϤǤޤ󤫤)

ŸʤʤäϤޤä狼ʤ
ͥåȤĴ٤Ƥߤȡɤ911TƱ褦ʸݤƤ¿褦Ǥ

Ȥꤢ٤˥åפˤäƹԤޤȤʤä硤¡ĢǡեΥǡäƤޤߤǡ줬ˤǤ͡Хååפⲿ⤷Ƥʤ

ȤauȤäƤäξ㤹ʤư٤̵äɤSoftBankΥ֥ɤȤʼʤΤ

ޤޤ饰äƤ̵Τǡ˽Фޤ

λҶ

Τˤʤᵯʤ
ϸ5޽˾׷⤬롪
Ȼפ䡤ɤ椬Ҥξ˥֤­޽ľ⤷褦
ʤ餽λ̲ӡܤФƤޤ

ΤϤäΤε˻Ҷᵯ򤹤Τ
٤ߤǤ줷ƶʳ롩䡤ޤλҶϤʻ狼ǯǤϤʤΤ

Ǥ⡤ᵯȤʤʬˤʤޤ͡
ʤǡ(Ѥ)ҶܳФޤספˤϴդƤޤ
ɤʤʿⵯߤΤǤɡʿʿٿ()

ޤáɤǤ衣˰äƤФ͡줯餤ϲޤäơ

̹οͤȥѡ󥰥֥졼

ĿϤḷߴޤϰοãϡ֤֤ݤ˥ѡ󥰥֥졼(ɥ֥졼)Ȥʤͤ¿ATʤ饷եȥС[P]ˤ졤MTʤ[1][R]Ƥ櫓Ǥ
ϡѡ󥰥֥졼(ϡѡ󥰥֥졼Υ磻䡼)ƲǤʤʤ붲줬뤫Ǥ

Ǥ⡤ǵ˻פѡ󥰥֥졼ȤʤΤߵʤޤ⡤ǯȤʤͤ¿ΤǤߵ֤ϾҤȤ뤹뤪줬ΤǻѤʤΤǤޤζ줬̵ߵʳǤʤȤʤΤġġ

ưֶǤΤǤ礦
ˤȤ顤뼫ưֶ꤬ޤ

AT˥ѡ󥰥֥졼פȤͤäƤ¿פʤ᡼ʤ櫓ǤäơɬפƤ롣

[P]ϥ߹äƥåǡ䤽ΤΤưƤ櫓ǤϤʤѡ󥰥֥졼ϡ(֥졼)ư롣

ʤߤˡμ֤MTǤߵѡ󥰥֥졼Ѥޤ
äơ뤹Τäƥ磻䡼˿ʬäơǻϤζ줬櫓Ǥñ˿ʬʤ

̹ξQ̹ʳQ

ȸ᤮⤷ʤ֤˴ؤƤϻϤ롣
Profile

Ԥ

livedoor ŷ
Access Counter
  • ߷ס

ˬ䤢꤬Ȥޤ

ASP
ninja tool
  • 饤֥ɥ֥