You can use LIKE in natively-compiled procedures, and that's enough:

-- Declare 2 strings: one with a bad character, and one without
DECLARE @BadChar varchar(128) = 'A funky char...

"I have to say that I don't understand the "/SQLSVCACCOUNT" switch or why its needed, but that seems to work."

SQL Express does not run as a program like the application...

You are correct in that SQL Server cares not what the source of the certificate is - an X.509 cert is an asymmetric key pair in a specific format. It's...

A Data Space is either a Filegroup or a Partition Scheme. Everything showing in your result with a Data Space Name that isn't a filegroup (or has a data_space_id that...

Check the Licensing Guide for SQL server (https://download.microsoft.com/download/e/2/9/e29a9331-965d-4faa-bd2e-7c1db7cd8348/SQL_Server_2019_Licensing_guide.pdf)

That doc is for 2019, but the relevant section hasn't changed for several versions.

Search the Licensing Guide for 'Downgrade rights'. A license for...

You PIVOT to turn row values into column names.

SQL Server does not provide dynamic PIVOT, you must specify the names for the new columns you want returned.

Because 'Dry', 'Fine' ('Fines'...

Add the 'ALL' option to your WHERE clause:

WHERE @Daygroup = 'ALL' OR DayGroup = @Daygroup

You need to provide an alias for the derived table in the query:

  from (select T0.ID,T1.SID,[dbo].[Planning](T1.Id,T0.SId) as Status
        ...

Instead of migrating, I'd just restore the database 6 times under 6 different names, then drop what isn't needed from each of them.

If you have foreign key constraints between tables...

Certification is a learning path that forces you out of your comfort zone.When I see someone with certs on their resume, I at least know they tried to get out...

If the connection's setting for CONCAT_NULL_YIELDS_NULL is ON (which must often be set to ON depending on use of other features), then adding a NULL string to a value string...

The problem with using IP address alone is that there's no indication that you wish to connect to the specific \SQLSRVR2008 instance.

If you set the IP port number for the...

Wrap the value of "riskDataRepeating" with braces (" { } ") instead of brackets (" [ ] "):

DECLARE @J2 NVARCHAR(MAX)

SET @J2 = '{
"riskDataRepeating": {
"TEST": [
{
"riskDataItem": {
"dataId": 123,
"label":...

The Serial value and the Queue name are both children of the queue nodes. Just use the path to the Serial value.

SELECT doc1.col.value('(@id)[1]', 'varchar(64)')   ...

SQL Server 2017 Developer Edition: https://go.microsoft.com/fwlink/?linkid=853016

That download is a small file; running it lets you choose to install directly or download the installation media.