How do I sort a VARCHAR column in SQL server that contains numbers?...

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text ind...

System.Data.SqlClient.SqlException: Column name or number of supplied values does not match table de...

TSQL transform JSON Array in each row...

How can I generate a temporary table filled with dates in SQL Server 2000?...

T-SQL query, select IF same IP is used by more than one user within a fixed timespan...

Transform result of a table via subquery...

nvarchar concatenation / index / nvarchar(max) inexplicable behavior...

How do I convert an int to a zero padded string in T-SQL?...

Remove values from JSON array based on values in another table...

Set-based approach to distributing a value SSMS TSQL...

SQL Group by Year...

T-SQL Split Word into characters...

Remove duplicate values in JSON Array...

Identify columns in a table that are referenced or used on other tables...

Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql st...

Get a list of tables accessed by a SELECT statement...

How to concatenate all the records in a column returned by a query into one varchar string in T-SQL?...

SQL updating column with a difference value of current and previous row...

Conditionally execute a query...

T-SQL to find a node within a dynamic XML structure...

Import specific JSON part into a table as rows...

How to calculate Employee Weekly OFF in a month...

TSQL select into Temp table from dynamic sql...

Create new row with data from another row/column...

ORDER BY items must appear in the select list if SELECT DISTINCT is specified...

SQL LIKE operator not working for comma-separated lists...

Dynamic display mask that hides the Customer Phone Numbers in the Customers table...

Retrieve specific JSON properties from JSON collection in SQL Server column using a SQL query...

using OUTPUT in a update statement...