Search code examples
Please create a master key in the database or open the master key in the session before performing t...


sqlencryptioncertificatesql-server-2016private-key

Read More
Compare a few columns for 2 different dates in same table, return what is different?...


sqlsql-serversql-server-2016

Read More
How to find an average time to complete a task for a given period...


sqlsql-serversql-server-2016

Read More
Custom Authentication (Security Extension) with SSRS 2016...


sql-serverreporting-servicessql-server-2016ssrs-2016

Read More
Insert results of linked server into temp table from SQL Server 2016 to SQL Server 2019...


sql-server-2016linked-serversql-server-2019sp-executesql

Read More
OPENJSON does not work in SQL Server?...


sql-serverjsonsql-server-2016

Read More
Convert Hex Data in an Image Field to String...


sqlsql-serversql-server-2016

Read More
Entity Framework: How to make DataGridView Sortable?...


vb.netdatagridviewvisual-studio-2015entity-framework-6sql-server-2016

Read More
SQL pivot based on fuzzy condition...


sqlt-sqlpivotsql-server-2016gaps-and-islands

Read More
Update an existing JSON Value inside JSON array...


jsonsql-serversql-server-2016

Read More
Query fast, but when in a VIEW, it's slow - due to ROW_NUMBER...


sqlsql-serversql-server-2016

Read More
Incorrect syntax near format in BULK INSERT?...


sqlsql-serversql-server-2016

Read More
Identify if date is the last date for any given group?...


sqlsql-serversql-server-2016

Read More
SUBSTRING does not limit string length. Specified 32, got 256...


sql-serversql-server-2016sqlcmd

Read More
SQL Server Not Recognizing Leading Spaces in Select Query...


sql-server-2016

Read More
SQL - LAG but skip specific rows based on value?...


sqlsql-serversql-server-2016

Read More
Insert records from TABLE_A to TABLE_B without inserting any duplicates...


sqlduplicatessql-server-2016

Read More
SQL - only increment ROW_NUMBER() on specific values...


sqlsql-servert-sqlsql-server-2016

Read More
SQL - calculate total value of group, row by row...


sqlsql-serversql-server-2016

Read More
Formatting XML with `GO` into a set of sql commands to be executed...


sql-serverxmlsql-server-2016dynamic-sqlfor-xml

Read More
OpenJson store processed object in original form...


sql-servert-sqlsql-server-2016open-json

Read More
TSQL FOR JSON nested value...


jsonsql-servert-sqlsql-server-2016

Read More
STRING_AGG is not a recognized built-in function name...


sqlsql-serversql-server-2016

Read More
Converting an array of numbers in a Json to a SQL table...


sql-serversql-server-2016

Read More
Apply SQL Server schema after 'schema compare' show error...


sql-server-2016azure-data-studioschema-compare

Read More
Cumulative sum and cumulative count in sql...


sqlsql-serversql-server-2016

Read More
How to select string Rows from MS SQL Json String array?...


sql-serversql-server-2016sql-server-json

Read More
Multiple Pivot with an existing sql query working contains pivot...


sqlpivotsql-server-2016

Read More
SQL - Minus Payment amount from rows in ascending order?...


sqlsql-server-2016

Read More
SQL server database port parameter in configuration file...


sql-serversql-server-2016

Read More
BackNext