Maphunziro a SQLCMD Otsogolera

Microsoft SQL Server Command Line Utility

Microsoft SQL Server imapereka ogwiritsa ntchito zosiyanasiyana zojambula zojambula zojambulajambula kuti zithetse ndikuyendetsa deta ndi kupanga SQL Server zolinga . Komabe, nthawi zina zimakhala zosavuta kugwira ntchito kuchokera ku mzere wachikale wolamulira. Kaya mukuyang'ana njira yowonongeka komanso yonyansa yakuyesa funso la SQL kapena mukufuna kufotokozera mawu a SQL mu fayilo ya Windows, SQLCMD ikukuthandizani kukwaniritsa cholinga chanu. Nkhaniyi ikusonyeza kuti muli ndi Microsoft's AdventureWorks Sample Database yowonjezera.

01 ya 05

Kutsegula Lamulo Lamulo

Kuti muthe kuyendetsa SQLCMD, muyenera choyamba kutsegula mzere wa malamulo wa Windows. Mu Windows XP, dinani Yambani> Thamangani ndiyeno muyimire CMD mulemba bokosi musanatseke. Mu Windows Vista, dinani pawindo la Windows , yesani mtundu wa CMD mu Search box ndikusindikizani ku Enter .

Muyenera kuwona tsamba la Mawindo la Windows.

02 ya 05

Kulumikizana ku Database

Mukangoyamba kutsegulira lamulo, gwiritsani ntchito ntchito ya SQLCMD kuti mugwirizane ndi deta. Mu chitsanzo ichi, tikugwirizanitsa ndi database ya AdventureWorks2014, kotero timagwiritsa ntchito lamulo:

sqlcmd -d AdventureWorks2014

Izi zimagwiritsa ntchito mazenera otsimikizirika a Windows kuti agwirizane ndi deta yanu. Mukhozanso kutanthauzira dzina la eni pogwiritsa ntchito -B flag ndi mawu achinsinsi pogwiritsa ntchito -P mbendera. Mwachitsanzo, mukhoza kulumikizana ndi deta pogwiritsa ntchito dzina la "mike" ndi mawu achinsinsi "goirish" ndi mzere wotsatira:

sqlcmd -Muke -P goirish -d AdventureWorks2014

03 a 05

Kulowa Pepala

Yambani kulemba mawu a SQL pa 1> mwamsanga. Mungagwiritse ntchito mizere yambiri momwe mukufunira funso lanu, kukanikiza fungulo lolowamo pakatha mzere uliwonse. SQL Server sichita funso lanu mpaka mwachangu akulamulidwa kuti muchite zimenezo.

Mu chitsanzo ichi, timalowa mufunso lotsatira:

SANKHA * FROM FROMResources.shift

04 ya 05

Kuchita Query

Mukakonzekera funso lanu, lembani lamulo LOWANI pa mzere watsopano wa malamulo mkati mwa SQLCMD ndikusindikizani ku Enter . SQLCMD imayankha funso lanu ndipo imasonyeza zotsatira pawindo.

05 ya 05

Kutuluka SQLCMD

Pamene mwakonzeka kuchoka SQLCMD, lembani lamulo EXIT pa mzere wopanda lamulo kuti mubwerere ku tsamba la Mawindo la Windows.