官术网_书友最值得收藏!

Installing SQL Server 2012 Command Line Utilities

The command-line utilities are needed to run SQL sentences and scripts onto the database instance. You may feel more comfortable with the full SQL Server Management Studio Express, which is also free to download and use. For simplicity, and not to overload the machine, I will be using only the command line during the recipes.

Getting ready

You need to have completed the previous recipe to continue.

How to do it...

As in the previous recipes, execute the following steps in a command prompt window:

  1. Install SQL Server 2012 Command Line Utilities by running:
    C:\install\SqlCmdLnUtils.msi
    
  2. Accept the agreement, allow permission if prompted, and click on Next until the end.

There's more...

Check successful outcome with the following command:

sqlcmd -S (localdb)\v11.0

This should connect to the default instance of SQL Server. It may take a while as the SQL Server instance is loaded on demand, so when you issue this command for the first time, Windows actually has to run the sqlservr.exe executable. From the second time, the instance will be loaded faster.

Note

You can watch a screencast of this operation at:

主站蜘蛛池模板: 东海县| 蓬莱市| 寻乌县| 肇源县| 锦屏县| 乌拉特后旗| 宁强县| 三都| 兴海县| 凤冈县| 东乌珠穆沁旗| 卫辉市| 韶关市| 双峰县| 十堰市| 马鞍山市| 平度市| 曲阜市| 治多县| 沛县| 司法| 德昌县| 兰溪市| 鲁山县| 广河县| 南丹县| 武强县| 阿坝县| 建始县| 家居| 东莞市| 定州市| 临颍县| 惠水县| 乌拉特中旗| 沙雅县| 正镶白旗| 罗山县| 靖远县| 灯塔市| 德庆县|