SQLCMD Step-by-Step Tutorial

Whakamahi Raina Raina Tautuhinga Microsoft SQL

E whakarato ana a Microsoft SQL Server i nga kaiwhakamahi ki te maha o nga waahanga kaiwhakamahi whakairoiro whaimana mo te tango me te whakamahi i te raraunga me te whirihora i nga papaaraunga SQL Server . Heoi, i etahi wa he mea noa ake te mahi i te raina whakahau tawhito. Ahakoa e rapu ana koe i tetahi huarahi tere me te poke kia mahia he uiui SQL, ka hiahia ranei koe ki te whakauru i nga tauākī SQL i roto i te kōnae hōtuhi Windows, ka taea e SQLCMD te whakatutuki i tō whāinga. Kei te tuhinga tenei kua whakauruhia e Microsoft AdventureWorks Sample Database.

01 o 05

Te whakatuwhera i te whakahau

Hei whakahaere i te SQLCMD, me whakatuwhera tuatahi koe i te whakamahinga raina whakahau Windows. I te Windows XP, pāwhiritia te Tīmata> Whakahaere , ka patohia te CMD i te pouaka kuputuhi i mua i te pāwhiri OK . I te Windows Vista, pāwhiritia te pātene Windows , patohia te CMD ki te pouaka Rapu me te pēhi i te tomo .

Me kite koe i te arataki whakahau Windows.

02 o 05

Hono ana ki te Paerewa

I te wa e tuwhera ana koe i te whakahau, tuhia te whakamahinga SQLCMD hei hono atu ki te pātengi raraunga. I roto i tenei tauira, kei te hono atu matou ki te pātengi raraunga AdventureWorks2014, na ka whakamahia e matou te whakahau:

sqlcmd -d AdventureWorks2014

Ka whakamahia e te whakamahi i nga waitohu Windows taunoa hei hono atu ki to papamahi. Ka taea hoki e koe te tautuhi i tetahi ingoa kaiwhakamahi ma te whakamahi i te haki -U me te kupuhipa ma te whakamahi i te tohu--Pana. Hei tauira, ka taea e koe te hono atu ki te pātengi raraunga ma te whakamahi i te ingoa kaiwhakamahi "mike" me te kupuhipa "goirish" me te raupapa whakahau e whai ake nei:

sqlcmd -U mike -P goirish -d AdventureWorks2014

Tuhinga o mua

Te whakauru i te Uiui

Tīmatahia te tuhi i te tauākī SQL i te urupare 1>. Ka taea e koe te whakamahi i te maha o nga raupapa e hiahia ana koe mo to uiui, me te patene i te matua tomo i muri i ia raina. Kaore e tuhia e te Kaihautū SQL a raatau uiui kia akonahia ki a koe kia mahia.

I tenei tauira, ka whakauruhia e matou te uiui e whai ake nei:

WHAKATAHI * MAI i te HumanResources.shift

04 o te 05

Te Mahi i te Uiui

Ina rite koe ki te whakaoti i to uiui, tuhia te whakahau GO ki tetahi raina whakahau hou i roto i te SQLCMD me te tautuhi tomo . Ka whakahaeretia e SQLCMD to uiui me te whakaatu i nga hua i runga i te mata.

Tuhinga o mua

Kei te haere i te SQLCMD

A, no te mea kua rite koe ki te puta i te SQLCMD, pato i te whakahau EXIT i runga i te rarangi whakahau korepa kia hoki mai ki te urupare whakahau a Windows.