Search code examples
Generating self-closing XML tags for lists in SQL Server...


sql-servert-sqlsql-server-2019for-xmlselect-for-xml

Read More
Conditionally filter results of query based on a single flag...


sqlsql-servert-sqlsql-server-2019

Read More
Unable to install SQL Server(setup.exe) Exit code decimal: -2061893606...


sqlsql-serverdatabasesql-server-2019

Read More
Advanced SQL Server LIKE pattern...


sqlsql-serverfiltersql-server-2019

Read More
SQL Server database copy utility fails - "Login failed for user"...


sql-serversql-server-2012data-migrationsql-server-2019

Read More
Search a JSON with multiple array elements for specific attribute and get another attribute value...


jsonsql-servert-sqlsql-server-2019

Read More
How to decrement a number in a character-separated string...


sqlsql-servert-sqlsql-server-2019

Read More
Is there a way to ignore the "STATISTICS_NORECOMPUTE" clause when doing a schema compare i...


databaseazure-sql-databasevisual-studio-2022sql-server-2019schema-compare

Read More
How to find value for SSIS package project parameter manually set in the SQL Server Agent job?...


sql-serverssissql-server-2019sql-server-agentssis-2019

Read More
Add a value on their SESSION_CONTEXT for all sys.dm_exec_sessions...


sql-serversql-server-2019

Read More
Only on one server: "SQL Server Network Interfaces: The target principal name is incorrect.&quo...


sql-server-2019spn

Read More
Select top 1 row from multiple rows in inner join...


sqlsql-serverjoinsql-server-2019

Read More
Two elements with the same name for xml path()...


sql-serverxmlt-sqlsql-server-2019for-xml-path

Read More
How to concatenate T-SQL script with a wildcard and to be more dynamic?...


sql-servert-sqlconcatenationsql-server-2019

Read More
Get latest row based by date grouped by concat...


sqlsql-server-2019

Read More
Recursive CTE for leave accrual projections...


sqlsql-serversql-server-2019

Read More
Entity Framework truncating decimal places when updating table...


c#sql-serverentity-frameworksql-server-2019

Read More
Query to parse JSON using openrowset converting special characters...


jsonsql-serversql-server-2019

Read More
Why does normal execution resume after Raiserror in Catch block...


sql-serversql-server-2019

Read More
Get values of columns A of table 1 and values of column B of table 2 with same ID...


sqlsql-serversql-server-2019

Read More
How to use EXECUTE AS in a procedure without giving a USER explicit IMPERSONATE permissions?...


sql-serversql-server-2019

Read More
Simple insert times out in application, but fast in SSMS...


sql-serversql-execution-plansql-server-2019

Read More
Trying to preserve data types when duplicating a table, dynamically...


sqlsql-servert-sqlsql-server-2019

Read More
Edit asterisk symbol into list of column names in SSMS by wildcard expansion...


sqlsql-serversql-server-2008sql-server-2017sql-server-2019

Read More
JSON_MODIFY() embeds escape characters...


sqlarraysjsonsql-server-2019

Read More
Remove substring between two characters in SQL Column...


sqlsql-serversql-server-2019

Read More
Calculate end date of partition rows using start date of following partition...


sqlsql-servert-sqlsql-server-2012sql-server-2019

Read More
SQL adding rows to each row...


sqlsql-serversql-server-2019

Read More
Executing Stored Procedures across Different Databases...


sqlsql-serversql-server-2019

Read More
SSIS encrypt and trustservercertificate connection parameters not working...


sql-serverssissql-server-2019

Read More
BackNext