Học lập trình Spatial với SQL server cho người mới bắt đầu

8,))<4)68v7:3-')’

-27507)6:)6

&IKMRRMRK

7TEXMEP

[MXL7507IVZIV

%PEWXEMV%MXGLMWSR

,EVRIWWXLITS[IVSJ7507IVZIVvWWTEXMEPJIEXYVIWIXXS

GVIEXIPSGEXMSRFEWIHEREP]WMWERHZMWYEPM^EXMSRXSSPW

&IKMRRMRK7TEXMEP

[MXL7507IVZIV

%PEWXEMV%MXGLMWSR

&IKMRRMRK7TEXMEP[MXL7507IVZIV

'ST]VMKLXF]%PEWXEMV%MXGLMWSR

%PPVMKLXWVIWIVZIH2STEVXSJXLMW[SVOQE]FIVITVSHYGIHSVXVERWQMXXIHMRER]JSVQSVF]ER]QIERW

IPIGXVSRMGSVQIGLERMGEPMRGPYHMRKTLSXSGST]MRKVIGSVHMRKSVF]ER]MRJSVQEXMSRWXSVEKISVVIXVMIZEP

W]WXIQ[MXLSYXXLITVMSV[VMXXIRTIVQMWWMSRSJXLIGST]VMKLXS[RIVERHXLITYFPMWLIV

-7&2TFO 

-7&2IPIGXVSRMG 

4VMRXIHERHFSYRHMRXLI9RMXIH7XEXIWSJ%QIVMGE

8VEHIQEVOIHREQIWQE]ETTIEVMRXLMWFSSO6EXLIVXLERYWIEXVEHIQEVOW]QFSP[MXLIZIV]SGGYVVIRGI

SJEXVEHIQEVOIHREQI[IYWIXLIREQIWSRP]MRERIHMXSVMEPJEWLMSRERHXSXLIFIRIJMXSJXLIXVEHIQEVO

S[RIV[MXLRSMRXIRXMSRSJMRJVMRKIQIRXSJXLIXVEHIQEVO

0IEH)HMXSV.SREXLER+IRRMGO

8IGLRMGEP6IZMI[IV)ZER8IVV]

)HMXSVMEP&SEVH'PE]%RHVIW7XIZI%RKPMR1EVO&IGORIV)[ER&YGOMRKLEQ8SR]'EQTFIPP

+EV]'SVRIPP.SREXLER+IRRMGO1MGLIPPI0S[QER1EXXLI[1SSHMI.IJJVI]4ITTIV*VERO4SLPQERR

&IR6IRS['PEVOI(SQMRMG7LEOIWLEJX1EXX;EHI8SQ;IPWL

4VSNIGX1EREKIV/]PMI.SLRWXSR

'ST])HMXSV&MPP1G1ERYW

%WWSGMEXI4VSHYGXMSR(MVIGXSV/EVM&VSSOW'STSR]

4VSHYGXMSR)HMXSV/EXMI7XIRGI

'SQTSWMXSV7YWER+PMRIVX

4VSSJVIEHIV%TVMP)HH]

-RHI\IV.YPMI+VEH]

'SZIV(IWMKRIV/YVX/VEQIW

1ERYJEGXYVMRK(MVIGXSV8SQ(IFSPWOM

(MWXVMFYXIHXSXLIFSSOXVEHI[SVPH[MHIF]7TVMRKIV:IVPEK2I[=SVO-RG7TVMRK7XVIIXXL*PSSV

2I[=SVO2=4LSRI746-2+)6JE\IQEMPSVHIVWR]$WTVMRKIVWFQGSQSV

ZMWMXLXXT[[[WTVMRKIVSRPMRIGSQ

*SVMRJSVQEXMSRSRXVERWPEXMSRWTPIEWIGSRXEGX%TVIWWHMVIGXP]EX8IPIKVETL%ZIRYI7YMXI

&IVOIPI]'%4LSRIJE\IQEMPMRJS$ETVIWWGSQSVZMWMXLXXT

[[[ETVIWWGSQ

%TVIWWERHJVMIRHWSJ)(FSSOWQE]FITYVGLEWIHMRFYPOJSVEGEHIQMGGSVTSVEXISVTVSQSXMSREPYWI

I&SSOZIVWMSRWERHPMGIRWIWEVIEPWSEZEMPEFPIJSVQSWXXMXPIW*SVQSVIMRJSVQEXMSRVIJIVIRGISYV7TIGMEP

&YPO7EPIWzI&SSO0MGIRWMRK[IFTEKIEXLXXT[[[ETVIWWGSQMRJSFYPOWEPIW

8LIMRJSVQEXMSRMRXLMWFSSOMWHMWXVMFYXIHSRERwEWMWxFEWMW[MXLSYX[EVVERX]%PXLSYKLIZIV]TVIGEYXMSR

LEWFIIRXEOIRMRXLITVITEVEXMSRSJXLMW[SVORIMXLIVXLIEYXLSVRSV%TVIWWWLEPPLEZIER]PMEFMPMX]XSER]

TIVWSRSVIRXMX][MXLVIWTIGXXSER]PSWWSVHEQEKIGEYWIHSVEPPIKIHXSFIGEYWIHHMVIGXP]SVMRHMVIGXP]F]

XLIMRJSVQEXMSRGSRXEMRIHMRXLMW[SVO

8LIWSYVGIGSHIJSVXLMWFSSOMWEZEMPEFPIXSVIEHIVWEXLXXT[[[ETVIWWGSQ

8S'PEVIERH(SYKPEW

MZ

'SRXIRXWEXE+PERGI

%FSYXXLI%YXLSV \\M

%FSYXXLI8IGLRMGEP6IZMI[IV \\MMM

%GORS[PIHKQIRXW \\Z

-RXVSHYGXMSR  \\ZMM

4%68 ;SVOMRK[MXL7TEXMEP(EXE

',%48)6 (IJMRMRK7TEXMEP-RJSVQEXMSR

',%48)6 -QTPIQIRXMRK7TEXMEP(EXEMR7507IVZIV

',%48)6 ;SVOMRK[MXL7TEXMEP(EXEMRXLI2)8*VEQI[SVO

4%68 %HHMRK7TEXMEP(EXE

',%48)6 'VIEXMRK7TEXMEP(EXE3FNIGXW 

',%48)6 1EVOMRK3YX+ISQIXVMIW9WMRK:MVXYEP)EVXL 

',%48)6 -QTSVXMRK7TEXMEP(EXE 

',%48)6 +ISGSHMRK 

Z

4%68 4VIWIRXMRK7TEXMEP(EXE

',%48)6 7]RHMGEXMRK7TEXMEP(EXE 

',%48)6 4VIWIRXMRK7TEXMEP(EXE9WMRK;IF1ETTMRK7IVZMGIW

',%48)6 :MWYEPM^MRK5YIV]6IWYPXWMR1EREKIQIRX7XYHMS

4%68 %REP]^MRK7TEXMEP(EXE

',%48)6 )\EQMRMRK4VSTIVXMIWSJ7TEXMEP3FNIGXW

',%48)6 1SHMJ]MRK7TEXMEP3FNIGXW 

',%48)6 8IWXMRK7TEXMEP6IPEXMSRWLMTW

4%68 )RWYVMRK7TEXMEP4IVJSVQERGI

',%48)6 -RHI\MRK

-2()< 

ZMM

'SRXIRXW

%FSYXXLI%YXLSV \\M

%FSYXXLI8IGLRMGEP6IZMI[IV \\MMM

%GORS[PIHKQIRXW \\Z

-RXVSHYGXMSR  \\ZMM

4%68 ;SVOMRK[MXL7TEXMEP(EXE

',%48)6 (IJMRMRK7TEXMEP-RJSVQEXMSR 

;LEX-W7TEXMEP(EXE# 

9WIWSJ7TEXMEP(EXE 

6ITVIWIRXMRK*IEXYVIWSRXLI)EVXL 

4SMRXW 

0MRI7XVMRKW

4SP]KSRW 

'LSSWMRKXLI6MKLX+ISQIXV]

'SQFMRMRK+ISQIXVMIWMRE+ISQIXV]'SPPIGXMSR

9RHIVWXERHMRK-RXIVMSVW)\XIVMSVWERH&SYRHEVMIW

4SWMXMSRMRKE+ISQIXV] 

(IWGVMFMRK4SWMXMSRW9WMRKE'SSVHMREXI7]WXIQ

+ISKVETLMG'SSVHMREXI7]WXIQ

4VSNIGXIH'SSVHMREXI7]WXIQ 

%TTP]MRK'SSVHMREXI7]WXIQWXSXLI)EVXL

(EXYQ 

4VMQI1IVMHMER

9RMXSJ1IEWYVIQIRX 

4VSNIGXMSR

9WMRK7TEXMEP6IJIVIRGI7]WXIQW 

7TEXMEP6IJIVIRGI-HIRXMJMIVW

ZMMM '328)287 

7TEXMEP6IJIVIRGIWMR7507IVZIV 

)\TVIWWMRK7TEXMEP6IJIVIRGIWMRXLI;IPP/RS[R8I\X*SVQEX

'SRXVEWXMRKE+ISKVETLMGERHE4VSNIGXIH7TEXMEP6IJIVIRGI 

'SQTEVMRK7TEXMEP6IJIVIRGI7]WXIQW 

;+7 

2EXMSREP+VMHSJ+VIEX&VMXEMR

7YQQEV] 

',%48)6 -QTPIQIRXMRK7TEXMEP(EXEMR7507IVZIV 

9RHIVWXERHMRK(EXEX]TIW

'SQTEVMRK7TEXMEP(EXEX]TIW 

8LIKISKVETL](EXEX]TI 

'SSVHMREXI7]WXIQ 

9RMXSJ1IEWYVIQIRX

7TEXMEP6IJIVIRGI-(

7M^I0MQMXEXMSRW

6MRK3VMIRXEXMSR 

8LIKISQIXV](EXEX]TI

'SSVHMREXI7]WXIQ 

9RMXSJ1IEWYVIQIRX 

7TEXMEP6IJIVIRGI-(

6MRK3VMIRXEXMSR 

'LSSWMRKXLI6MKLX7TEXMEP(EXEX]TI 

'SRWMWXIRG] 

%GGYVEG] 

8LI)RHW SJXLI;SVPH

4VIWIRXEXMSR 

4IVJSVQERGI 

7XERHEVHW'SQTPMERGI 

,S[7TEXMEP(EXE-W7XSVIH 

'SRZIVXMRK&IX[IIR(EXEX]TIW 

7TEXMEPP])REFPMRK=SYV8EFPIW 

'VIEXMRKE2I[8EFPI

%HHMRKXSER)\MWXMRK8EFPI 

)RJSVGMRKE'SQQSR76-( 

7YQQEV] 

'328)287 M\

',%48)6 ;SVOMRK[MXL7TEXMEP(EXEMRXLI2)8*VEQI[SVO

;LEX-WXLI2)8*VEQI[SVO#

,S[2)8-W,SWXIH 

;L]9WI2)8JSV7TEXMEP*YRGXMSREPMX]# 

%TTP]MRK4VMRGMTPIWSJ3FNIGX3VMIRXEXMSR 

(EXE%FWXVEGXMSR 

)RGETWYPEXMSR(EXE,MHMRK 

-RLIVMXERGI

4SP]QSVTLMWQ 

-RWXERXMEXMRK7TEXMEP3FNIGXW

9WMRK7XEXMG1IXLSHW 

%TTP]MRKE7XEXMG1IXLSHSJXLI%TTVSTVMEXI(EXEX]TI

-RZSOMRK7TEXMEP-RWXERGI1IXLSHW 

8750*YRGXMSR7]RXE\

2)8'06-RWXERGI1IXLSH7]RXE\

'LEMRMRK1YPXMTPI1IXLSH'EPPW

%GGIWWSVERH1YXEXSV1IXLSHW 

%GGIWWMRK4VSTIVXMIW

7]RXE\ 

6IEH3RP]ERH6IEH;VMXI4VSTIVXMIW 

'SQFMRMRK8750ERH2)8'061IXLSHW 

9WMRK3TIR+ISWTEXMEP'SRWSVXMYQ1IXLSHW 

,ERHPMRK)\GITXMSRWMRXLI'06 

7YQQEV] 

4%68 %HHMRK7TEXMEP(EXE

',%48)6 'VIEXMRK7TEXMEP(EXE3FNIGXW

'LSSWMRKER%TTVSTVMEXI7XEXMG1IXLSH

'VIEXMRK+ISQIXVMIWJVSQ;IPP/RS[R8I\X 

'VIEXMRKE4SMRXJVSQ;/8 

'VIEXMRKE0MRI7XVMRKJVSQ;/8

'VIEXMRKE4SP]KSRJVSQ;/8

'VIEXMRKE1YPXM4SMRXJVSQ;/8 

'VIEXMRKE1YPXM0MRI7XVMRKJVSQ;/8 

'VIEXMRKE1YPXM4SP]KSRJVSQ;/8 

'VIEXMRKE+ISQIXV]'SPPIGXMSRJVSQ;/8

'VIEXMRK%R]/MRHSJ+ISQIXV]JVSQ;/8 

6ITVIWIRXMRKER)\MWXMRK+ISQIXV]%W;/8 

\ '328)287 

'VIEXMRK+ISQIXVMIWJVSQ;IPP/RS[R&MREV]

'VIEXMRKE4SMRXJVSQ;/& 

'VIEXMRKE0MRI7XVMRKJVSQ;/& 

'VIEXMRKE4SP]KSRJVSQ;/& 

'VIEXMRKE1YPXMIPIQIRX+ISQIXV]JVSQ;/&

'VIEXMRK%R]8]TISJ+ISQIXV]JVSQ;/& 

6ITVIWIRXMRKER)\MWXMRK+ISQIXV]%W;/& 

'VIEXMRK+ISQIXVMIWJVSQ+ISKVETL]1EVOYT0ERKYEKI

7XVYGXYVISJE+10(SGYQIRX

(IGPEVMRKXLI+102EQIWTEGI

1IXLSHWXS-RWXERXMEXI+ISQIXV]3FNIGXWJVSQ+10 

'VIEXMRKE4SMRXJVSQ+10 

'VIEXMRKE0MRI7XVMRKJVSQ+10

'VIEXMRKE4SP]KSRJVSQ+10

'VIEXMRKE1YPXM4SMRXJVSQ+10 

'VIEXMRKE1YPXM0MRI7XVMRKJVSQ+10 

'VIEXMRKE1YPXM4SP]KSRJVSQ+10 

'VIEXMRKE+ISQIXV]'SPPIGXMSRJVSQ+10

6ITVIWIRXMRKER)\MWXMRK+ISQIXV]%W+10 

7YQQEV] 

',%48)6 1EVOMRK3YX+ISQIXVMIW9WMRK:MVXYEP)EVXL

'VIEXMRKXLI;IF%TTPMGEXMSR 

'VIEXMRKE2I[;IF7MXI 

%HHMRKE&EWMG1ET

)\XIRHMRKXLI1ET*YRGXMSREPMX]

%HHMRK'SRXVSPWXS,8104EKILXQ

9WMRKXLI;IF%TTPMGEXMSR 

'VIEXMRKE+ISQIXV]JVSQXLI;/83YXTYX 

7YQQEV] 

',%48)6 -QTSVXMRK7TEXMEP(EXE 

7SYVGIWSJ7TEXMEP(EXE

-QTSVXMRK8EFYPEV7TEXMEP(EXE

-QTSVXMRKXLI8I\X*MPI 

%HHMRKXLIKISKVETL]'SPYQR 

4STYPEXMRKXLI7TEXMEP'SPYQR 

'328)287 \M

-QTSVXMRK(EXEJVSQ/I]LSPI1EVOYT0ERKYEKI 

'SQTEVMRK/10XS+10 

8VERWJSVQMRK/10XS+10

-QTSVXMRK(EXEJVSQ)76-7LETIJMPI*SVQEX 

3FXEMRMRK7EQTPI7LETIJMPI(EXE 

-QTSVXMRK7LETIJMPI(EXE[MXL7LETI750

9WMRK8LMVH4EVX]'SRZIVWMSR8SSPW

'SQQIVGMEP8SSPW 

*VII8SSPW 

7YQQEV] 

',%48)6 +ISGSHMRK

;LEX-W+ISGSHMRK#

1ET4SMRX;IF7IVZMGI 

%GGIWWMRKXLI1ET4SMRX;IF7IVZMGIJVSQ7507IVZIV

7MKRMRK9TJSVXLI1ET4SMRX;IF7IVZMGI 

'VIEXMRKXLI2)8%WWIQFP] 

'VIEXMRKE2I[4VSNIGX 

'SRJMKYVMRKXLI4VSNIGX

%HHMRKXLI+ISGSHMRK*YRGXMSR 

'SQTMPMRKXLI%WWIQFP]

'SRJMKYVMRKXLI(EXEFEWI 

)REFPMRK'067YTTSVX

7IXXMRK7IGYVMX]4IVQMWWMSRW

-QTSVXMRKXLI%WWIQFP] 

'VIEXMRKXLI*YRGXMSR 

9WMRKXLI+ISGSHI*YRGXMSR

7YQQEV] 

4%68 4VIWIRXMRK7TEXMEP(EXE

',%48)6 7]RHMGEXMRK7TEXMEP(EXE

;L]7]RHMGEXI7TEXMEP-RJSVQEXMSR#

7]RHMGEXMSR*SVQEXW

8LI+IS677*SVQEX 

+IS6777TEXMEP)RGSHMRKW

6IPEXMRK7TEXMEP-RJSVQEXMSR[MXLXLI+IS677 [LIVI"8EK

\MM '328)287 

%XXEGLMRK7TEXMEP-RJSVQEXMSRXSE*IIH 

'VIEXMRKE+IS677*IIH 

'VIEXMRKXLI7EQTPI(EXE

7IVZMRKXLI+IS677*IIH 

8IWXMRKXLI*IIH,ERHPIV

'SRWYQMRKXLI+IS677*IIH

9WMRKXLI+SSKPI1ETW;IF7MXI 

9WMRK)QFIHHIH+SSKPI1ETW 

9WMRK1MGVSWSJX:MVXYEP)EVXL 

9WMRK=ELSS1ETW 

7YQQEV] 

',%48)6 4VIWIRXMRK7TEXMEP(EXE9WMRK

;IF1ETTMRK7IVZMGIW

8LI%TTPMGEXMSR 

4VSGIWW3ZIVZMI[ 

3FXEMRMRKXLI7SYVGI(EXE

'VIEXMRKE2I[;IF7MXI4VSNIGX 

'VIEXMRKXLI,8104EKI 

6IJIVIRGMRKXLI%4- 

-RGPYHMRKXLI.EZE7GVMTX

7TIGMJ]MRKXLI1ET'SRXEMRIV 

6IZMI[MRKXLI,8104EKI

'VIEXMRKXLI7XEXMG.EZE7GVMTX

(IGPEVMRKXLI1ET3FNIGX 

0SEHMRKXLI+SSKPI1ETW%4-

7IXXMRK'EPPFEGOWXS0SEHERH9RPSEHXLI1ET

'VIEXMRKXLI1ET 

'SRJMKYVMRKXLI1ET 

%HHMRK-RXIVEGXMZMX] 

'VIEXMRKER%.%<3FNIGX 

6IUYIWXMRK(EXE

'PIEVMRKXLI1ET

9THEXMRKXLI7XEXYW;MRHS[ 

(MWTSWMRKSJXLI1ET 

6IZMI[MRKXLI.EZE7GVMTX

'VIEXMRKXLI7XSVIH4VSGIHYVI

'328)287 \MMM

'VIEXMRKXLI;IF,ERHPIV

'VIEXMRKE'SRRIGXMSRXS7507IVZIV 

'EPPMRKXLI7XSVIH4VSGIHYVI

'SRWXVYGXMRKXLI+ISQIXV])PIQIRXW 

%HHMRKE7LETIXSXLI1ET 

%XXEGLMRK(IWGVMTXMZI-RJSVQEXMSRXSXLI1ET 

'YWXSQM^MRKXLI%TTIEVERGISJ1ET)PIQIRXW

6IZMI[MRKXLI2)8,ERHPIV 

:MI[MRKXLI4EKI 

*YVXLIV%TTPMGEXMSRW 

7YQQEV] 

',%48)6 :MWYEPM^MRK5YIV]6IWYPXWMR1EREKIQIRX7XYHMS

7507IVZIV1EREKIQIRX7XYHMS 

:MWYEPM^MRK7TEXMEP6IWYPXW 

'LSSWMRK:MWYEPM^EXMSR3TXMSRW 

7YTTSVXIH4VSNIGXMSRW 

)UYMVIGXERKYPEV

1IVGEXSV 

6SFMRWSR 

&SRRI 

7YQQEV] 

4%68 %REP]^MRK7TEXMEP(EXE

',%48)6 )\EQMRMRK4VSTIVXMIWSJ7TEXMEP3FNIGXW 

6IXYVRMRKXLI2EQISJE+ISQIXV]8]TI 

7YTTSVXIH(EXEX]TIW 

9WEKI 

)\EQTPI 

6IXYVRMRKXLI2YQFIVSJ(MQIRWMSRW3GGYTMIHF]E+ISQIXV] 

7YTTSVXIH(EXEX]TIW 

9WEKI 

)\EQTPI