t-sql Examples and Free Source Code

T-SQL: Single-Query Join with either one Table or another...

sql t-sql left-join

use Row_number after applying distinct...

sql sql-server t-sql stored-procedures pagination

Multiple recursive union all selects in a CTE SQL query...

sql-server t-sql common-table-expression

how to pass Order By @col name through variable in a paging enabled Query...

sql .net sql-server t-sql pagination

Converting simple T-SQL query to Paging enabled Query inside stored proc...

sql sql-server t-sql stored-procedures pagination

Duplicate table structure dynamically - how to manage float datatype...

sql-server t-sql types automation

Flag all bosses in meeting based on org tree...

sql-server t-sql hierarchical-data

Modifying an existing index: Create index with drop_existing=on vs. alter index statement...

sql-server t-sql

Counting no of rows returned by a select query...

sql-server sql-server-2008 t-sql

Adding paging to my ASP.NET GridView...

c#asp.net t-sql gridview pagination

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

sql-server xml t-sql sql-server-2019 for-xml-path

SQL Server FOR XML Path make repeating nodes...

sql sql-server xml t-sql

Handling cycles in topological sorting in T-SQL...

sql-server t-sql topological-sort

How to order by with string_agg...

sql-server t-sql string-aggregation

How to pass an array into a SQL Server stored procedure...

c#sql-server t-sql stored-procedures

Error trying copy a table into another without duplicates...

sql sql-server t-sql

How to safely change the unique key with Entity Framework - database-first...

c#visual-studio entity-framework t-sql

How to update only 2 columns of table and save as new record?...

c#sql-server t-sql

How can I use if statement after a CTE (SQL Server 2005)...

sql sql-server sql-server-2005 t-sql common-table-expression

SQL Scheduled job query, duration of last runs?...

sql-server t-sql sql-server-2000

SQL XML How to query specific node...

sql sql-server xml t-sql

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

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

Text was truncated or one or more characters had no match in the target code page including the prim...

sql sql-server t-sql ssis

How do you change the datatype of a column in T-SQL Server?...

sql-server t-sql type-conversion alter-table

Count just working days (exclude weekends and public holidays) and add filter that a query...

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

Fill remaining dates between dates in SQL Server...

sql-server date t-sql

tSQLt - How to fake/mock sequences...

sql-server unit-testing t-sql tsqlt

Check if a varchar is a number...

t-sql numerical-methods

PATINDEX to detect letters and six numbers...

sql sql-server t-sql sql-server-2012

T-SQL: what COLUMNS have changed after an update?...

sql-server sql-server-2005 t-sql