Thuto ea SQLCMD Mehato ea Bohato ka Bohato

Microsoft SQL Server Command Line Utility

Microsoft SQL Server e fana ka basebedisi ba mefuta e fapaneng ea marang-rang a marang-rang a sebedisang bakeng sa ho fumana le ho hlophisa ditaba le ho lokisa maralo a SQL Server . Leha ho le joalo, ka linako tse ling ho bonolo ho sebetsa ho tloha molaong oa taelo ea khale. Ho sa tsotellehe hore na u batla tsela e potlakileng le e litšila ea ho hlahisa potso ea SQL kapa u lakatsa ho kenyelletsa lipolelo tsa SQL ho file ea script ea Windows, SQLCMD eu lumella ho finyella pakane ea hau. Sehlooho sena se nka hore u se u ntse u e-na le Microsoft's AdventureWorks Sample Database e kentsoeng.

01 ea 05

Ho bula Lenaneo la Taelo

E le hore u tle u tsamaee SQLCMD, u tlameha ho qala ho bula lenaneo la tšebeliso ea molaetsa oa Windows. Ho Windows XP, tobetsa Qala> Tsamaea mme o thaepa CMD ka lebokose la lebokose pele o tobetsa OK . Ho Windows Vista, tobetsa konopo ea Windows , thapa mofuta oa CMD ka lebokoseng la ho batla ebe o kenya Inthanete .

U lokela ho bona mohato oa litaelo tsa Windows.

02 ea 05

Ho kopanya le Database

Hang ha u se u e-na le taelo ea taelo, sebelisa sQLCMD tshebediso ho ikamahanya le databases. Mohlala ona, re kopana le database ea AdventureWorks2014, ka hona re sebelisa taelo:

sqlcmd -d AdventureWorks2014

Sena se sebedisa ditshwantsho tsa Windows tsa kamehla ho hokahanya le hau. U ka boela ua hlalosetsa lebitso la hau le sebedisa -U flag le password ka le -P flag. Ka mohlala, u ka ikopanya lebenkeleng ho sebelisa lebitso la "mike" le "password" goirish ka mola o latelang oa taelo:

sqlcmd -Meke -P goirish -d AdventureWorks2014

03 ea 05

Ho kenya Potso

Qala ho thapa polelo ea SQL ho 1> prompt. U ka sebelisa mela e mengata kamoo u batlang bakeng sa potso ea hau kateng, u hatelletse konopo ea ho kena kamora 'ngoe. SQL Server ha e phethe potso ea hau ho fihlela e laeloa hore e etse joalo.

Mohlala ona, re kenya potso e latelang:

SELECT * FROM HumanResources.shift

04 ea 05

Ho Etsa Potso

Ha u se u itokiselitse ho phethisa ts'ebetso ea hau, tlanya taelo GO holim'a mohala o mocha oa litaelo ka hare ho SQLCMD mme o tobetsa Enter . SQLCMD e phethahatsa potso ea hau mme e bonts'a liphello ho skrine.

05 ea 05

Ho tsoa SQLCMD

Ha o se o loketse ho tsoa SQLCMD, thapa taelo EXIT molaong oa taelo o se nang letho ho khutlela Windows prompt command.