If you’re using OPENJSON(), but you’re trying to remember how to select an inner fragment from the JSON document, read on.
Tag: t-sql
Merge Two Partitions into One in SQL Server (T-SQL)
In SQL Server, you can use the ALTER PARTITION FUNCTION to merge two partitions into one partition.
To do this, use the MERGE RANGE argument, while providing the boundary value of the partition to drop.
This operation drops the partition and merges any values that exist in the partition into a remaining partition.
Continue readingSplit a Partition into Two in SQL Server (T-SQL)
If you have a partitioned table or index in SQL Server, but you need more partitions, you can add a partition to the partition function using the ALTER PARTITION FUNCTION statement with the SPLIT RANGE argument.
When you do this, you split an existing partition into two.
Continue readingHow to Fix “Only one expression can be specified in the select list…” in SQL Server
In SQL Server, error message 116 occurs when you try to select multiple columns in a subquery without introducing it with the EXISTS operator.
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.
Continue readingHow 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.
Continue readingHow 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.
Continue readingHow 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.
Continue readingHow 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.
Continue readingHow 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).
Continue reading