In SQL Server, error message 116 occurs when you try to select multiple columns in a subquery without introducing it with the EXISTS operator.
mssql
How to Install SQL Server on Linux
Starting from SQL Server 2017, you can now install SQL Server on Linux.
More specifically, you an install it on Ubuntu, Red Hat (RHEL), and SUSE.
Below are instructions for installing SQL Server on each of these Linux distributions.
How to Fix “The partition scheme ‘…’ does not have any next used filegroup” in SQL Server
You’ll get error 7710 if you try to split a partition in SQL Server, but you haven’t specified a “next used” filegroup.
How to Install sqlcmd & bcp on Red Hat
If you’ve installed SQL Server on your Red Hat machine, you’ll need some tools to connect to it and run queries, etc.
The sqlcmd and bcp utilities are a couple of good options for helping you perform the most common tasks.
How to Install sqlcmd & bcp on SUSE
If you’ve installed SQL Server on your SUSE machine, you’ll need some tools to connect to it and run queries, etc.
The sqlcmd and bcp utilities are good options for performing the most common tasks.
How to Install sqlcmd & bcp on Ubuntu
If you’ve installed SQL Server on your Ubuntu machine, you’ll need some sort of tool to connect to it.
Installing the sqlcmd and bcp utilities is good place to start.
SSMS Now Comes with Azure Data Studio
I recently installed the latest release of SSMS (SQL Server Management Studio) and saw that Azure Data Studio was automatically installed with it.
The release notes confirm that this is the case starting from SSMS 18.7 (which was released on October 20, 2020:
Beginning with SQL Server Management Studio (SSMS) 18.7, Azure Data Studio is automatically installed alongside SSMS. Users of SQL Server Management Studio are now able to benefit from the innovations and features in Azure Data Studio. Azure Data Studio is a cross-platform and open-source desktop tool for your environments, whether in the cloud, on-premises, or hybrid
How to Install SQL Server on Windows
In this article, I show you how to install SQL Server on a Windows machine (screenshots included).
In this case I used the installation wizard to install SQL Server 2019 onto a Windows 10 machine, using the Basic installation option, which uses the default configuration.
How to Install SSMS
SSMS (SQL Server Management Studio) is a graphical tool that you can use to administer SQL Server.
SSMS used to be bundled with SQL Server, but that is no longer the case. You must now install it separately.
This article shows you how to install SSMS (including screenshots).
Note that SSMS is only available for Windows machines. If you’re using a non-Windows machine (such as Mac or Linux), try Azure Data Studio or perhaps DBeaver.
Also note that Azure Data Studio is now included when you install SSMS (starting with SSMS 18.7).
How to Install SQL Server on SUSE 12
This article provides step-by-step instructions for installing SQL Server 2019 for Linux on SUSE Linux Enterprise Server 12.
These steps should work on SUSE Linux Enterprise Server 12, SP2, SP3, SP4, and SP5.
You should have at least 2GB of memory before you install SQL Server on your SUSE machine. If you’re installing this on a virtual machine, you should have at least 2GB of memory allocated to it.
The file system must be XFS or EXT4.