SQLCMD I-Step-by-Step Tutorial

I-Microsoft SQL Server Command Line Utility

I-Microsoft SQL Server inikezela abasebenzisi ngeendlela ezahlukeneyo zokusebenzisa imizobo yomsebenzisi yokubuyisela nokukhupha idatha kunye nokuqwalasela iinkcukacha zeSQL Server . Nangona kunjalo, ngamanye amaxesha kulula ukuba usebenze kumgca wolawulo oludala. Ingaba ukhangele indlela ekhawulezayo-engcolileyo yokuphumeza umbuzo we-SQL okanye unqwenela ukufaka izitatimende ze-SQL kwifayili ye-Windows, iSQLCMD ikuvumela ukuba uhlangabezane nomgomo wakho. Eli nqaku libonisa ukuba sele unayo i-Microsoft's AdventureWorks iSampuli yeSampuli efakwe.

01 ngo 05

Ukuvula i-Command Prompt

Ukuze usebenze i-SQLCMD, kufuneka uqale uvule umsebenzisi womgca womyalelo we-Windows. Kwi-Windows XP, qhafaza Qala> Hamba uze uthayiphe i- CMD kwibhokisi yombhalo ngaphambi kokuchofoza OK . Kwi-Windows Vista, nqakraza iqhosha le- Windows , thayipha i- CMD kwibhokisi lokukhangela uze ucinezela Faka .

Umele ubone i-Windows command prompt.

02 we 05

Ukuxhuma kwiDatabase

Emva kokuba unomyalelo wokuvula umyalelo, vela i-SQLCMD isebenzisi ukuxhuma kwi-database. Kulo mzekelo, sixhuma kwi-database ye-AdventureWorks2014, ngoko sisebenzisa umyalelo:

sqlcmd -d AdventureWorks2014

Oku kusetyenziswa iziqinisekiso zeWindows ezizenzekelayo ukuxhuma kwi-database yakho. Ungacacisa igama lomsebenzisi usebenzisa i-flag kunye nephasiwedi usebenzisa i-flag yePP. Umzekelo, unokudibanisa kwiziko ledatha usebenzisa igama lomsebenzisi "i-mike" kunye nephasiwedi "goirish" ngoluhlu lomyalelo olandelayo:

I-sqlcmd -I-mike -P i-goirish -d AdventureWorks2014

03 we 05

Ukufaka Umbuzo

Qala ukuthayipha isitatimende se-SQL kwi-1> ngokukhawuleza. Ungasebenzisa imigca emininzi njengoko ufuna umbuzo wakho, ucinezela ukhiye wokungena emva komgca ngamnye. I-SQL Server ayiyi kuqhuba umbuzo wakho kuze kube yilapho uyala ukuba wenze njalo.

Kulo mzekelo, sifaka umbuzo olandelayo:

UKUKHETHA * KUNYE KWEBantuResources.shift

04 we 05

Ukuqhuba Umbuzo

Xa ulungele ukuphumeza umbuzo wakho, thayipha umyalelo Hamba kumgca womyalelo omtsha ngaphakathi kwi-SQLCMD uze ucinezela u- Enter . I-SQLCMD iqhuba umbuzo wakho kwaye ibonisa iziphumo kwisikrini.

05 we 05

Ukuphuma kweSQLCMD

Xa ulungele ukuphuma kwi-SQLCMD, thayipha umyalelo QAPHELA kumgca womyalelo ongenanto ukuze ubuyele kwi-Windows command prompt.