t-sql Examples and Free Source Code

How to retrieve 10 distinct values of the last records?...

sql-server t-sql

Use of MERGE reserved keyword in different versions of SQL Server...

sql-server t-sql sql-server-2012 sql-server-2014 compatibility-level

Linking entities in EF Core...

c#t-sql entity-framework-core

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

sql sql-server t-sql sql-server-2019

sp_executesql In Loop Taking FOREVER to Run. Slowing down as it runs. Memory Leak?...

sql-server t-sql dynamic-sql sp-executesql

Why does using CONVERT(DATETIME, [date], [format]) in WHERE clause take so long?...

sql sql-server t-sql

Optimizing SQL Server performance: merging budget and actuals tables after same CTE transformations ...

sql-server t-sql

Combining (concatenating) date and time into a datetime...

sql sql-server sql-server-2008 t-sql datetime

How to see the execution plan of a multi-statement table valued function in SQL Server?...

sql sql-server t-sql ssms sql-execution-plan

Used statistics from XML plan cache for query with given QueryPlanHash...

sql-server xml t-sql xml-parsing sql-execution-plan

TSQL: ORDER BY - either use a column or nothing (empty)...

sql t-sql

Workaround maximum key length for a nonclustered index in SQL Server...

sql sql-server database t-sql

Query to create new data column with alphabetical concatenating the data...

sql sql-server t-sql concatenation

String_Agg concatenating duplicated value when there is multiple Ids exist...

sql sql-server t-sql

Convert varchar to datetime without millisecond...

sql sql-server t-sql

GROUP BY clause with a sum of zero (and non-zero) data...

sql sql-server t-sql

Difference from the first row but aggregating from second row till the end...

sql sql-server t-sql

XML output from SQL Server based on header and details...

sql-server xml t-sql xpath

Can I add a not null column without DEFAULT value...

sql sql-server sql-server-2005 t-sql

Filter out codes under certain conditions...

sql t-sql where-clause

Identify and label each branch in a hierarchical structure...

sql-server t-sql grouping common-table-expression hierarchy

SELECT INTO USING UNION QUERY...

sql sql-server t-sql union derived-table

STRING_SPLIT and ROW_NUMBER() - maintaining order...

sql-server t-sql window-functions

How to convert number of minutes to hh:mm format in TSQL?...

sql-server t-sql sql-server-2008 type-conversion datediff

Retrieving last record in each group from database - SQL Server 2005/2008...

sql-server-2005 t-sql sql-server-2008 distinct

What is the difference between using a cross join and putting a comma between the two tables?...

sql sql-server t-sql select cross-join

How to split a single column values to multiple column values?...

sql sql-server t-sql string

Loading JSON file with nested elements into a T SQL table...

json sql-server t-sql nested

Given a view in SQL Server with a union query, can I find out which source columns from each source ...

sql-server t-sql

Generate row for each month year if product sold in that year...

sql-server t-sql