SQLserver數(shù)據(jù)庫使用指引

SQLserver數(shù)據(jù)庫使用指引

一、數(shù)據(jù)庫查詢

1.數(shù)據(jù)庫登錄打開SQLserver輸入賬號密碼進行登錄

文忤(D漏輯。Sfi(V)工具(DEDW)牡區(qū)?部助00

上延說直畫GO白出⑦nJ&總

怫然后便費s

陶,雪」■

2.數(shù)據(jù)庫新建查詢

文件?編輯⑥查看9調(diào)試也）工具①窗口⑥社區(qū)?群助?

，新建查詢?tin他%20&天

寸象米源管理器▼Qx

隹接，會卷，T團旦

□0

L.136,220(SQLServer10.50.1600-JR-VH-DTG0

國ldo

一一

B全-

性

安

芳

對

象■雙擊數(shù)據(jù)庫，

@器

服

制

sM復儲存的數(shù)據(jù)目

理

s管列表

E

Server代理

文件9編輯⑥宣百⑦頊目9廊t@）工具⑴窗口W社區(qū)?秋助如

^母串I’

SQUJnerylT..tr.t.r(54))

連接，弟霆■▼國./

S10.1.136220(SQLServer10.50.1600-JR-VM-T,

￡)CJ數(shù)據(jù)摩

S1口系統(tǒng)數(shù)據(jù)摩

根據(jù)需要查詢的數(shù)據(jù)，編寫SQL語句，點擊執(zhí)行，可以出現(xiàn)查詢的數(shù)據(jù)結(jié)果（在寫語句的

時候需要注意庫名、表名、字段名需要跟數(shù)據(jù)庫產(chǎn)品說明書中保持一致）

例如

（1）查詢商品期貨白銀（AG1809）7月4日的分筆數(shù)據(jù)，并按照交易時間進行排序，可以

寫

select*fromGTA_MFL1_TAQ_.MFL1_TAQ_AG1809201807WHERETradingDate

between**and1*ORDERBYTradingTime

女伴<z)，naa)s??)9i3<a)項目<z)i眼?IMa)Baat)社區(qū)?磬助on

工第鰭詞<DGHB由匕-H，0為老祖|auwWLZOM".!幀8,■?薩皿回月'?勾10圈a二？*尊

s?-0

?二&WH_T*Q_A1905j201?H

用：34WLl_TW_AlWTj20ia(n直詢字段〉

用23*?Bn.l_TAQ_A?*)9_2OI9aT查詢數(shù)據(jù)時間

S)nq?WU_T*Q_M9U_20J80T*代表全字段庫名

??34U

WLl_T*0jlZ；1608_201?n

另：34WLt_TAQ_M；10O9_2Ol?n

S;二1???H.l_TW_*G>81O^OI8(n

閨：□4im_1_TW_*G18n_20>?0T

a34UWll_T*Q>5>?12.20ian:□結(jié)果|」消息I

同nmWU_T*9_fcG1901J01?n

$2jSMNEIhadrpD力|^必爾皿

：il□BH.I_TM_WJwe_20IWT7

2J2,AGieo9amia?"46X004143

it]□4UBH.l_TM}_*G1903_20180T-

?!□4Bn.l_T?jK；lft)4j20180T3AGW白瀛18092C600COW143

-

擊□&?WLI_T*Q_AG1?I5_2O1WT4AG1803白爆18092C60000MU3

-

第二I4?n.l_TW_*3JW6JMlWT5AG18O9白愎18092reaxxxMU3

：fi□4.Kn.l_T*Q_*OK?_20J?n

AG18O9BIS18092CM00004U3

■□dWH_T?_*aKe_20J?nTI-

7

?I□0Wll_TM)_AU8(n^01?n-AG1909Qffi18O92060000W143

8

H：□如Wll.TWJXiae^MlWT-AG18O9白穗18092C6000004143

9

s□&?nni_TW_Mj?9_a)i?n-AG18O9白MU3

陽□a?Mn.l_T*l}_*U8)0_20180T旦AG18O9白愎1809205000001143

?I□4UBni-TAQ-AUSll-ZOiaOT

AG18O3BIS18O92060X)004143

，，：□4WU_TN_AU812-20師11I

-AG1809BW18O92060000W143

:另na*wit.TwjojwijMiaoT旦

3i□4fe.?ll_T?_AU902_20180TAG18O9白瀛18092C600C004U3

旦

3□BH.I_T*fi_AU903_201?nAG18O9白銀18092C60000MU3

.14WU_MAU?K一20I80T旦

￡AG18O9白愎1809205000001143

g?n.l_TW_AUW5_20180TAG1809BW18O9205000004143

SI：□三Wil_T*Q_MJ??_201807國

?J□?n.l_TM)_*Unj_20180T2AG1809BW18O920600004143

M：34KFLl_TM)_*I*J2_20180TAG19O9B?18O92060000(X143

(2)查詢商品期貨白銀(AG1809)7月2日到7月5日的分筆數(shù)據(jù)，并按照交易時間排序，

可以寫

select*fromGTA_MFL1_TAQ_.MFL1_TAQ_AG1809_201807WHERETradingDate

between''and''ORDERBYTradingTime

Sts01)￡C(V)董海?)項目G)調(diào)試8)iMff)EDA)社區(qū)(T)WK)01)

彳酸￡曰⑦與匚)idJ以￡*bAOUJMl如除?!執(zhí)行0)，；：,國廠90圉9二

SQ!jQ??rl-S--?t?r(54))?:__

select"fromGTAJPLlJTA-ni：.?:[:就AUHE近3rotnng0ace'ZB靠品

□dbo?FU_r*0_A1905_2018073

Kndb?WLI.TWJUWT^ZOISOT-

EE□曲?！鰎u.TW.AJaw.zoiso?

□db。?FU_T?_AJ9>)_2OI8O7語句中的表名

t￡□dboWU_TMJ_AG18(n_201B0?度跟數(shù)據(jù)庫中的

<ib。.1111nmgai8_2(neo?嚷名保持一致

db?WuZrAQ>?l&J9.201857~~^

dboWLl_lW_WiJ81O_2Oi8O?_

S□dbo?FLl_T*0_?；18J1^201807

-21db。WLI_TAQ_M；18I2_2OIW?n培M口淌包I

正□db??FL1_TM}_AG190)_201807

S加日|ShortNwe|SecuMD|TM@Me|T，的Thw|L*rfVic.|HH/PIB|LonPioe|T，?d?VoM??|IaWc*uw|IwyoMn*|Pi?Toitf>ca6cn|TaaPotiWn|

比□dbo?FLI_TM)_AGI?2_2O18O?

*□dboWLl_TM}_*G19(n_201807B?i￡03

St□dbtWU_rM)_*GJ904.20180?白銀1O0

仔□dboWU_T*0_*G1905^018076181609

；

,3db?,WLl_T?_*JW>6_20ie<R白爆1609201s

莊：□曲。?FLI_T?_*^?W1.201807

白銀1SB201

S21db。?FLI_TW_AO?2_20180?20120

!￡二Idb。WU_TW_MjarT_20l80701818?20120

白愎1609201s201

*'□Abo?FU_TJUiJlM808.20180?

201

電□dbo.WLl_r?JJJ809_201807affiiae201

201201

E□db?WL1_T*OJJJ81O_2O18O7白鐵1809201201

百□db??FLl_T*0_AU811^201807s201

BtRie?20

EE□dboWU_TAQ_MJ812_201807201

自懼

if□db??FU_TW_MJ901.20180718ra201

□dbo?FU_TM)_AU9a2_20lB07自銀1期201

*□dboWU_TA1}_*U903.201807白爆1009

,□db?WU_TM)JJJ90?_2016C?白銀1809205000004143201806-2921:00.081000370100000000.000Q00000QOO118ZOO118200

(3)查詢商品期貨白銀(AG1809)6月2日到7月5日的分時數(shù)據(jù)，并按照交易時間排序

select*fromGTA_MFL1_TRDMIN_.MFLl_TRDMIN01_201806WHERE

symbol=1AG1809*andTradingDatebetween**and*1

unionall

select*fromGTA_MFL1_TRDMIN_.MFL1_TRDMINO1_201807WHERE

symbol=*AG1809*andTradingDatebetweenand1,

ORDERBYTradingTime

S&<^>弼&項目0）曦史必）lMa）￡□?）社區(qū)?赧助的

|必修翁心僦*⑶如口但口足如鰻?［，執(zhí)行9>■，器.學畫1。1公匾|€T二二I事串i公的

SQLQaeryls.tor(54))?.

-select-fromGTA_?FLi_TPtnIK_201806.dbo.MXLINOl_20180vWHERE-syntoo1-,*01809^an.4z

unionall

RH.：_T*Q_A190S_20l6(n

VLl_T?_*190?_2t?6O?select'fromGTA_HFL1_TRI>HIN_2O18O7.dbo.HFL1_TM>HIN01_201807WHEREsiutool-'AG1809'anddlngDatebetween*20100702,and*2018Q2Qg

ORDERBYTradingTlme)"

909.2018077月交l

WU_T?JU911^2018076月交易日

■n.：_T*Q_*CI80T_ZOl8(n

■n.l_7WJ_AG1808_20l8(n

■m_7*Q_*G1809_20l8trt

■n.!_T*Q_*>1810.201807

ffLl_T*ajW1811_2Oi8O7

BFU_7M_*<；l8l2_20t80T口結(jié)果I，消息I

Hn.!_TWJ_A01901_20l8Cf7

|Tr?ihflD“Ih如Tit|BwKhMiikOpwPfe*Op?iPrio?||UwPrio*|||BttPriotOg|8mP*c<03|BmPfoO

■FU_T?_*G1902_20180?

—

■n.l_T?_*51903_20l80?-自爆1803201806042018-0&0121:000000036920003692000XSZOOO363200036920903620000QOOO0.0000000

2

■n.l_T*QJW19(M_2O18OT3白根190920180G042018-06-0121:01:0000036920003E920003692(DO36320003sg200036720000000

-

RH.i_7*0_*GI90S_20tea?4白嫌190920180604201M6-0121OZOaOOO369200036820003692000368200036920003672000QOOO00000000

H7U_T*fl_*OI906_20l807-

5BtRl909201806042018-06-0121:0300000369200036S200036S2COO368200036920003S7G.OOO0000

VU_T?_*??01.201807-

KH.J.T?>?02Z2O18O76日惻的92018082018-0t012J04:00000為92000368200035820003632001369200038780000000

-白黑1期20180682018-0&0121O&OOOOO3692000368300036830003683000368300036760000000

Rn.l_7?_*L1807.20t8077

-白爆1809201B0GO42018-0&0121060Q000369200036830003C8200036830003E830003CSOOOO0000

"H4_T?_*L1808_2018OT8

RTU809_20l807-白想180920180E04201M6-0121070100036920003883.000388300036830003E830003681.000QOOO

9

UrU_T?_AL1810_20l?ff-BIB1909201806N2018-06-0121.08.0000036920003^30003C83.000368100036830003681.00000000000

■FU_I?_AL1811.201607

1-0日懂1809201806M20184)64)1210900.000369200036830003C8J000368J00036830003680.0000000

■FU_T?_*U812_2Ot8O7

1-1田R18C92018082018-06-012tWOOOOO3S920003683000368300036830003683000368000000000000

■H.1_T*0_AL190IJ201807S

WU_T*fl_ALl9O2_2OI8OT-自tRWM201806M20180&0121:110000036920003E8300036830003683OCO3683000368000000000000

■FU.TW.AU903_20ieO?1U3白銀180920180G04201806-0121120Q00036920003E830003C830003683000到03003G800000000

-

BH.1_TMI.AL1904.201807自嫌1809201806042018-064M21:1300000369200036830003683,0003683.00036830003680.00000000.0000000

WU_TM_AL19O5_2O18Crr

1-5日懼1909201806042018-06-012114.00.0003692000368300036S300036830003683000368200000000.0000000

■H4_T?_*L19O6_2O18OT旦

vStP.l0?201806M2018-064)12115000003692000統(tǒng).0003681000368300036830003682000000000000000

WU_TW_MJ?01.201807-

KTU_TeMJIO2_2O18O7AG16O9白銀1?201806820180&01211600000融000融000368300036830(?368300036840000W000000000

.2018071-8AG1SO9白帽190320180GM2018-0&012117:00000369200036820003682000368300036830003682000009000000000

旦

?n.l_T*Q_*M>2_201807AG18O9gtB1809201806012018-0&0121:180000036920003683000368300036830003E830003684000000000000000

?n.:_T?_*i'i807_20i8crr2-0205000004143AG18O9日懾201806042018-06-0121:190000036920003683.0003683,00036830033E830003684.00000000.0000000

三1809

■nj_TWa_API8IO_20l?X?

205C0OXM143AG18C0stRiaw201806042018-0t0121.200000036920003€83.0003683.000368300036830003684.00000000.0000000

BFU_T?_*P>811_2O18O7?

21KOOOOM143AG1809GtRiaw20180WM2018gM212.8.000369200036830003883000368300036830003688.000000000000000

■n.l_T?_AP1812_2O16O7衛(wèi)

■n.l_T?_*n901_20t8072Q5C000MU3AG18O92018060420180G-0121-22000X13692000融000朝000融000369800036870000000Q0000000

WU_T*fi_*F?W3jZOl8OT2-4206COXD<U3AG18O9自銀18）920180SM20180&0121210Q00036920003ES8000sseeooo3E880003E890003688000000000000000

?HJ_TW_*PI905_20l8072-52060X004143AG1803201806042018^6-0121:24:0000036920003E880003E88.0003689OX3G830003689.0000000Q0000000

Wll_T?_AP?Ol_2Ot8O??

205000004143AG18O9SIBiara20180604201WJ64J121:2500000369200036880003CS800036880003633000368800000000.0000000

■FU_T?_AMM2_2O18O7〃

-2O5CCCOCMU3AG18O9BIR1?9201806IM20121.26.000003692000被00036S6000368&0003683000368800000000.0000000

■n.l_T*fl_*V18O7_2Ol8Cr7?

■n.:_T*o_AVi8oe_2m?)7205000004143AG18O9臼愎1809201806M2018-06-0121:2700COO36920003688000闞000統(tǒng).00036880003684OCO00000.0000000

■7U_TW_AUI809_2t>ian2?920500COM143AG1SQ9BW1W92018068