Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2016

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

JSON - How to append an array to an array in sql

SQL Server 2016 Management studio regular update

How to get Hostname in T-SQL?

Why does MS-SQL-Server (all versions) cast 1.0/12.0 as numeric(8,6)?

Can an admin see encrypted data with SQL Server 2016 always encrypted feature?

Find Missing Dates in Data

SQL refusing connection in load test

Change data type from varchar to nvarchar for a table which has a large amount of data

SSRS Error - "Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate

Get a count based on the row order

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

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