SQLCMD Isinyathelo-by-Step Isifundo

I-Microsoft SQL Server Line Line Utility

I-Microsoft SQL Server inikezela abasebenzisi ngezixhumanisi ezihlukahlukene ezibonakalayo zomsebenzisi wokubuyisa ukuthola nokuphathwa kwedatha nokulungisa ulwazi lwe- SQL Server . Noma kunjalo, ngezinye izikhathi kulula nje ukusebenza kusuka kumugqa womyalo omdala. Kungakhathaliseki ukuthi ufuna indlela esheshayo-engcolile yokwenza umbuzo we-SQL noma ufisa ukufaka izitatimende ze-SQL kufayela le-Windows script, i-SQLCMD ikuvumela ukuba uhlangabezane nomgomo wakho. Lesi sihloko sinquma ukuthi usuvele une-Microsoft's AdventureWorks Sample Database efakwe.

01 ka 05

Ukuvula i-Command Prompt

Ukuze usebenzise i-SQLCMD, kumele uqale uvule umsizi womzila we-Windows umyalo. Ku-Windows XP, qhafaza Qala> Hamba bese uthayipha i- CMD ebhokisini lombhalo ngaphambi kokuchofoza OK . Ku-Windows Vista, chofoza inkinobho ye- Windows , thayipha i- CMD ebhokisini lokusesha bese ucindezela u- Enter .

Kufanele ubone i-Windows command prompt.

02 ka 05

Ukuxhuma kwi-Database

Uma une-prompt prompt open, sebenzisa isevisi ye-SQLCMD ukuxhuma ku-database. Kulesi sibonelo, sixhuma ku-database ye-AdventureWorks2014, ngakho-ke sisebenzisa umyalo:

I-sqlcmd-i-AdventureWorks2014

Lokhu kusebenzisa ukuqinisekiswa kwe-Windows okuzenzakalelayo ukuxhuma ku-database yakho. Ungase ucacise igama lomsebenzisi usebenzisa i-U flag kanye nephasiwedi usebenzisa i-flag ye -P. Isibonelo, ungaxhuma ku-database usebenzisa igama lomsebenzisi "mike" nephasiwedi "goirish" ngelayini lomyalo olandelayo:

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

03 ka 05

Ukufaka Umbuzo

Qala ukuthayipha isitatimende se-SQL ku-1> ngokushesha. Ungasebenzisa imigqa eminingi njengoba ufuna umbuzo wakho, ucindezela ukhiye we- Enter ngemuva komugqa ngamunye. Iseva ye-SQL ayisebenzisi umbuzo wakho kuze kufike ngokucacile ukuthi uyenze kanjalo.

Kulesi sibonelo, singena umbuzo olandelayo:

Khetha * FROM FROMResources.shift

04 ka 05

Ukusebenzisa Umbuzo

Uma usulungele ukukhipha umbuzo wakho, thayipha umyalo GO emgqeni womyalo omusha ngaphakathi kwe-SQLCMD bese ucindezela u- Enter . I-SQLCMD iqhuba umbuzo wakho futhi ibonisa imiphumela esikrinini.

05 ka 05

Iphuma ku-SQLCMD

Uma usulungele ukuphuma ku-SQLCMD, thayipha umyalo EXIT emgqeni wokulayina ongenalutho ukuze ubuyele kumyalezo we-Windows umyalo.