Make SQL 2014 OFFLINE BOOKS more findable, for T-SQL.

MightyPen · MightyPen · commit 0a66c8213f7c · 2019-12-11T00:25:43.000-08:00
diff --git a/docs/2014/2014-toc/index.yml b/docs/2014/2014-toc/index.yml
@@ -52,6 +52,8 @@ landingContent:
         url: /sql/samples/sql-samples-where-are?view=sql-server-2016
     - linkListType: reference
       links:
+      - text: T-SQL in SQL 2014 Offline Books
+        url: /sql/sql-server/sql-server-help-installation?view=sql-server-20165#use-help-viewer-v1x
       - text: INSERT data
         url: /sql/t-sql/statements/insert-transact-sql?view=sql-server-2016
       - text: SELECT - JOIN - GROUP BY
diff --git a/docs/2014/sql-server/what-s-new-in-sql-server-2016.md b/docs/2014/sql-server/what-s-new-in-sql-server-2016.md
@@ -1,7 +1,7 @@
 ---
 title: "What's New in SQL Server 2014 | Microsoft Docs"
 ms.custom: ""
-ms.date: 11/25/2019
+ms.date: 12/10/2019
 ms.prod: "sql-server-2014"
 ms.reviewer: ""
 ms.technology: install
@@ -22,8 +22,19 @@ manager: craigg
 
 This topic summarizes detailed links to new features in [!INCLUDE[ssSQL14](../includes/sssql14-md.md)] and summarizes services packs for [!INCLUDE[ssSQL14](../includes/sssql14-md.md)]  
  
-**Try it out:** ![Azure Virtual Machine small](./media/what-s-new-in-sql-server-2016/azure-virtual-machine-small.png)     Have an Azure account?  Then go **[Here](https://ms.portal.azure.com/?flight=1#create/Microsoft.SQLServer2014sp1EnterpriseWindowsServer2012R2)** to spin up a Virtual Machine with SQL Server 2014 Service Pack 1 (SP1) already installed. 
-  
+**Try it out:** ![Azure Virtual Machine small](./media/what-s-new-in-sql-server-2016/azure-virtual-machine-small.png)     Have an Azure account?  Then go **[Here](https://ms.portal.azure.com/?flight=1#create/Microsoft.SQLServer2014sp1EnterpriseWindowsServer2012R2)** to spin up a Virtual Machine with SQL Server 2014 Service Pack 1 (SP1) already installed.
+
+> [!NOTE]
+> [Click here](../2014-toc/index.yml) for the home documentation page for SQL Server 2014.
+
+<!--
+Do not let this file's filename fool you.
+This filename contains "2016", but nevertheless...
+This file, at this exact GitHub path, is dedicated to SQL Server version 2014.
+-->
+
+## What's New articles
+
 -   [What's New &#40;Database Engine&#41;](../database-engine/whats-new-in-sql-server-2016.md)  
   
 -   [What's New in Analysis Services and Business Intelligence](https://docs.microsoft.com/analysis-services/what-s-new-in-analysis-services)  
diff --git a/docs/sql-server/index.yml b/docs/sql-server/index.yml
@@ -48,6 +48,8 @@ landingContent:
         url: https://docs.microsoft.com/sql/samples/sql-samples-where-are
       - text: Internals & architecture guides
         url: https://aka.ms/sqlserverguides
+      - text: SQL Server 2014 docs
+        url: /sql/2014-toc/index.yml?view=sql-server-2014
       - text: Previous versions 2005-2014
         url: https://docs.microsoft.com/sql/toc/previous-versions-sql-server
 
diff --git a/docs/sql-server/sql-server-help-installation.md b/docs/sql-server/sql-server-help-installation.md
@@ -1,7 +1,7 @@
 ---
 title: SQL Server help content and Help Viewer | Microsoft Docs
 ms.custom: ""
-ms.date: "10/15/2019"
+ms.date: "12/10/2019"
 ms.prod: sql
 ms.technology: 
 ms.reviewer: ""
@@ -41,7 +41,9 @@ There are two major versions of the Microsoft Help Viewer.  Versions 1.x and 2.x
 
 ## Use Help Viewer v2.x
 
-**To download and install offline help content with Help Viewer v2.x**
+For this approach, Help Viewer 2.3 or later is recommended. The **Help** menu in the [latest version of SSMS.exe](../ssms/download-sql-server-management-studio-ssms.md) offers 2.3 or later.
+
+### To download and install offline help content with Help Viewer v2.x
 
 1. In SSMS or VS, click **Add and Remove Help Content** on the Help menu. 
 
@@ -89,11 +91,12 @@ There are two major versions of the Microsoft Help Viewer.  Versions 1.x and 2.x
 |*|Tools and utilities for Azure SQL Database | SQL Server tools|
 |*|Transact-SQL Reference (Database Engine) | Transact-SQL Reference|
 |*|XQuery Language Reference (SQL Server) | XQuery Language Reference (SQL Server)|
+| &nbsp; | &nbsp; | &nbsp; |
 
 > [!NOTE]
 > If the Help Viewer freezes (hangs) while adding content, change the Cache LastRefreshed="\<mm/dd/yyyy> 00:00:00" line in the %LOCALAPPDATA%\Microsoft\HelpViewer2.x\HlpViewer_SSMSx_en-US.settings or HlpViewer_VisualStudiox_en-US.settings file to some date in the future. For more information about this issue, see [Visual Studio Help Viewer freezes](/visualstudio/welcome-to-visual-studio).
 
-**To view offline help content in SSMS with Help Viewer v2.x**
+### To view offline help content in SSMS with Help Viewer v2.x
 
 To view the installed help in SSMS, press CTRL + ALT + F1, or choose **Add or Remove Content** from the Help menu, to launch the Help Viewer. 
 
@@ -105,7 +108,7 @@ The Help Viewer opens to the Manage Content tab, with the installed help table o
 
    ![Help Viewer v2.x with content](../sql-server/media/sql-server-help-installation/helpviewer2-withcontentinstalled.png)
 
-**To view offline help content in VS with Help Viewer v2.x**
+### To view offline help content in VS with Help Viewer v2.x
 
 To view the installed help in Visual Studio:
 1. Point to **Set Help Preference** on the Help menu and choose **Launch in Help Viewer**. 
@@ -120,9 +123,17 @@ To view the installed help in Visual Studio:
   
 ## Use Help Viewer v1.x
 
-Earlier versions of SSMS and VS use Help Viewer 1.x, which supports SQL Server 2014 and 2012 Help content. 
+In this section, you do the following general steps:
+
+- Manually download the SQL Server 2014 Offline Books, which are a set of four.
+- Use the **Help** menu of SSMS or VS to start the Help Viewer.
+- Finally, you tell the Help Viewer where the SQL Server 2014 `*.msha` file is on your local harddrive.
+
+Earlier versions of SSMS and VS provided the 1.x versions of the Help Viewer. 1.x is able to display the Offline Books for SQL Server versions 2012 and 2014. But 1.x cannot display the Offline Book for SQL Server 2016 or later.
+
+Help Viewer 2.3 is also able to display the SQL Server 2014 Offline Books, after you download the SQL Server 2014 Offline Books to your local harddrive.
 
-**To download and install offline help content with Help Viewer v1.x**
+### To download and install offline help content with Help Viewer v1.x
 
 This process uses Help Viewer 1.x to download SQL Server 2014 help from the Microsoft Download Center and install it on your computer.
 
@@ -150,7 +161,7 @@ This process uses Help Viewer 1.x to download SQL Server 2014 help from the Micr
    
 10. Click **Finish**, and then click **Exit**.
 
-**To view offline help content with Help Viewer v1.x**
+### To view offline help content with Help Viewer v1.x
 
 11. To view installed help, open **Help Library Manager**, click **Choose online or local help**, and then click **I want to use local help**.
 12. Open the Help Viewer to see the content by clicking **View Help** on the **Help** menu. The content you installed is listed in the left pane.  
@@ -163,13 +174,13 @@ This process uses Help Viewer 1.x to download SQL Server 2014 help from the Micr
 
 Online help always shows the most up-to-date content. 
 
-**To view SQL Server online help in SSMS 17.x**
+### To view SQL Server online help in SSMS 17.x
 
 - Click **View Help** in the **Help** menu. The latest SQL Server 2016/2017 documentation from [https://docs.microsoft.com/sql/sql-server/](https://docs.microsoft.com/sql/sql-server/) displays in a browser.
 
    ![View Help](../sql-server/media/sql-server-help-installation/viewhelp.png)
 
-**To view Visual Studio online help in Visual Studio**
+### To view Visual Studio online help in Visual Studio
 
 1. Point to **Set Help Preference** on the Help menu and choose either **Launch in Browser** or **Launch in Help Viewer**. 
 2. Click **View Help** in the Help menu. The latest Visual Studio help displays in the chosen environment. 
@@ -191,7 +202,7 @@ Online help always shows the most up-to-date content.
 
 When you press F1 or click **Help** or the **?** icon in a dialog box in SSMS or VS, a context-sensitive online help article appears in the browser or Help Viewer.
 
-**To view F1 help**
+### To view F1 help
 
 1. In the Help menu, click **Set Help Preference**, and choose either **Launch in Browser** or **Launch in Help Viewer**.
 2. Press F1, or click **Help**, or click **?** in dialog boxes where they are available, to see context-sensitive online articles in the chosen environment.
diff --git a/docs/toc/previous-versions-sql-server.md b/docs/toc/previous-versions-sql-server.md
@@ -3,7 +3,7 @@ title: Previous versions of SQL Server | Microsoft Docs
 author: MightyPen
 ms.author: genemi
 ms.reviewer: ""
-ms.date: "10/15/2019"
+ms.date: "12/10/2019"
 ms.topic: conceptual
 ms.prod: sql
 ms.technology: ""
@@ -60,7 +60,9 @@ Starting with SQL Server 2016, the SQL Server offline books have their version y
 
 ### Help Viewer
 
-For additional details about the Help Viewer tool, see [SQL Server offline help and Help Viewer](../sql-server/sql-server-help-installation.md?view=sql-server-2017).
+For additional details about the Help Viewer tool, see [SQL Server offline help and Help Viewer](../sql-server/sql-server-help-installation.md?view=sql-server-2016).
+
+Transact-SQL reference documentation is available in the Offline Books for SQL Server 2014. For more information, see the section named [Use Help Viewer v1.x](../sql-server/sql-server-help-installation.md?view=sql-server-2016#use-help-viewer-v1x).
 
 ## Lifecycle policy
 
