Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2016

Optimize JSON query processing in SQL Server 2016

How do I use OPENJSON on the result of a sub OPENJSON

json t-sql sql-server-2016

Get data as rows from array inside JSON column

How to JSON_MODIFY on Array of Array?

json sql-server-2016

Why do upserted INSERTED.ID and DELETED.ID both contain values after MERGE?

sp_helptext and definition of view being NULL

sql sql-server-2016

Merge two STRING_SPLIT

Result order of string_split?

Sql 2016 - How to get only modified column in system-versioned temporal table

Enable XA transactions for MSSQL Server docker image

How to convert multiple table output as child json in Sql

Strip numbers from string after certain characters into a recursive table

Using cross apply to query nested arrays in json

How best to store a password in SQL Server so that the password can be retrieved

LIKE with case sensitive wildcards

Can I improve the performance of this JSON conversion in SQL Server 2016?

Can I put a Clustered ColumnStore index on a table with NVARCHAR(MAX) fields?

Incorrect Syntax near the keyword 'OR' in CREATE OR ALTER PROCEDURE

Remove characters from text using TRANSLATE function (replace them with empty strings)

Alter Table 'DEFAULT' not setting default values - SQL Server