SQLCMD Step-by-Step Tutorial

Microsoft SQL Server Command Line Utility

Microsoft SQL Server inopa vashandi zvakasiyana-siyana zvekushandisa mufananidzo wemashandi ekugadzirisa nekugadzirisa deta uye kugadzira zvidzidzo zveSQL Server . Zvisinei, pane dzimwe nguva zviri nyore nyore kushanda kubva kumutsetse wekare-wakaita mutsara. Pasinei nokuti uri kutsvaga nzira yekukurumidza-isina-tsvina yekuita SQL mhinduro kana unoda kuisa zvinyorwa zveSQL mune faira reWindows, SQLCMD inokubvumira kuti usangane nechinangwa chako. Nyaya ino inofunga kuti iwe unotova neComputer Works Sample Database yaMicrosoft yakaiswa.

01 ye 05

Kuvhura Mutemo Wokukurumidza

Kuti uite SQLCMD, unofanira kutanga utanga Windows command line utility. MuWindows XP, tanga Start> Run uye tora CMD mumutauro bhokisi usati wanyora OK . MuWindows Vista, tora bhodhi reWindows, tora CMD muBhokisi reKutsvaga uye tapinda kuIta .

Unofanirwa kuona Windows command prompt.

02 of 05

Kubatana neDatabase

Kana uchinge uine mukana wekuraira, shandisa SQLCMD shanduro yekubatanidza kune database. Mumuenzaniso uyu, tiri kubatana neDynamicWorks2014 database, saka tinoshandisa murairo:

sqlcmd -d AdventureWorks2014

Izvi zvinoshandisa zvidzidzo zveWindows zvisingatauri kuti ubatanidze pane dhesi yako. Iwe unogonawo kutsanangura zita rekushandisa uchishandisa--U mureza uye password usinghandisa -P pendera. Semuenzaniso, unogona kuungana kune dhesiyo uchishandisa zita rekushandisa "mike" uye password "goirish" nerinotevera mutsara wemirairo:

sqlcmd -U mike -P goirish -d AdventureWorks2014

03 of 05

Kupinda Query

Tanga kuverenga svoti yeSQL pa 1> prompt. Iwe unogona kushandisa mitsetse yakawanda sezvaunoda kumubvunzo wako, kuvhara muIno yokupinda mushure mechikamu chimwe nechimwe. SQL Server haiti kukwanisa mhinduro yako kusvikira yakarayirwa kuti iite saizvozvo.

Mumuenzaniso uyu, tinopinda mubvunzo unotevera:

Sarudza * FROM FROMResources.shift

04 of 05

Kuita Chikumbiro

Paunenge wakagadzirira kupedza mubvunzo wako, tora mutemo GO pane imwe mutsara wemirairo mukati meSQLCMD uye tapinda ku Enter . SQLCMD inotarisa mubvunzo wako uye inoratidza mhinduro pahwindo.

05 of 05

Kubuda SQLCMD

Paunenge wakagadzirira kubuda SQLCMD, tora mutemo EXIT pane pasina murairo wemirairo kuti udzoke kuWindows command prompt.