How to use a Database Variable Name in dynamic SQL with visual studio for a SQL Server Project?...

Shredding XML in SQL Server 2017...

Add column to a huge table...

I am trying to add trailing '.' padding a string to a specific length...

If the table has more than one FOR INSERT trigger and one of them writes to an audit table and the o...

Starting with SQL Server 2017, there will be no more Service Packs (only Cumulative Updates). Won&#3...

Dynamically reorder column values in a SQL Server table...

SQL Server : get all data from one table but condition on 2nd tables column...

How to connect to an Azure SQL Server using command prompt?...

Use @@RowCount for multiple updates...

Get Same Quarter Revenue From Previous Year...

Aggregate values in columns ONLY there is a difference...

SSIS, fire events and the execution reports...

Sum value in periodic time...

Use if in where statement...

Left join causes huge performance drop. How to fix it...

Left-join EXCLUDING matching records?...

Do not include fixed value in JSON SQL...

Execute a stored procedure to update each row before inserting...

Generate cryptographic-secure random numbers within a natively-compiled procedure...

SQL Server 2017 Table-valued Functions - filtering with multiple values instead of just one...

SQL 2017 Linux ag resource not failing over with pacemaker...

SQL Server : joining 2 tables where each row has unique PKEY value...

How to update Table 1 from Table 2 when they have nothing in common?...

How to update Table 1 from multiple other tables when they have nothing in common?...

How to resolve comma separated values in a set based manner?...

Select multiple values from a single underlying values as a table...

Achieve the same result from this postgresql query in SQL Server 2017...

Generate nested JSON for data...

Add a condition to a table-valued function...