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

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:

主站蜘蛛池模板: 葫芦岛市| 新民市| 盈江县| 北海市| 徐闻县| 内黄县| 峡江县| 崇阳县| 安宁市| 绍兴市| 漾濞| 巴马| 卫辉市| 柯坪县| 古浪县| 尼勒克县| 施秉县| 唐海县| 阿合奇县| 遵义县| 秦皇岛市| 二手房| 靖宇县| 融水| 枣庄市| 紫阳县| 南和县| 台北市| 曲沃县| 错那县| 商水县| 乐陵市| 林甸县| 南川市| 肥东县| 建水县| 章丘市| 韩城市| 宁津县| 江油市| 抚宁县|