t-sql Examples and Free Source Code

Using regular expressions to remove all the GOs in a sql script file...

c#regex t-sql

What causes @summary variable to fail in SQL Server stored procedure?...

sql-server t-sql stored-procedures

Subtracting values from separate source table sequentially/ running values...

sql sql-server t-sql

SQL Server Left Join With 'Or' Operator...

sql sql-server t-sql left-join

How to get the first available number in a range...

sql sql-server t-sql

"Adding a value to a 'datetime' column caused an overflow."...

sql-server function t-sql date sql-server-2008-r2

What is the significance of 1/1/1753 in SQL Server?...

sql-server t-sql datetime localization internationalization

SQL Server : query columns to JSON object with group by...

sql json sql-server t-sql

How to select record from 5th row without using where query in SQL Server...

sql-server t-sql pagination

Put stored procedure result set into a table variable without specifying its schema...

sql-server t-sql sql-server-2008

How to identify all stored procedures referring a particular table...

sql t-sql stored-procedures sql-server-2005

SQL Server stored procedure with ROW_NUMBER...

sql-server t-sql stored-procedures pagination sql-server-2012

Nested Subquery vs Derived table...

sql-server t-sql subquery derived-table

LAST_VALUE function not working as expected...

sql-server t-sql

How to append 'OPTION (MAXDOP 1)' to SQLAlchemy select statement?...

python sql-server t-sql sqlalchemy

Better techniques for trimming leading zeros in SQL Server?...

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

Aggregate bitwise-OR in a subquery...

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

How can I group time by hour or by 10 minutes?...

sql sql-server-2008 t-sql group-by

TSQL Calculate week number of the month...

sql-server t-sql

SQL Proc Modification Question...

.net t-sql sql-server-2008 stored-procedures pagination

TSQL Pseudo Random text generator...

sql t-sql random

T-SQL SELECT DISTINCT & ROW_NUMBER() OVER Ordering Problem...

sql-server t-sql pagination

Sort Month Name in SQL Query...

sql sql-server sorting t-sql

When should I use semicolons in SQL Server?...

sql-server t-sql

SQL Server TRY...CATCH Is Not Catching An Error...

sql-server t-sql try-catch

Truncate (not round) decimal places in SQL Server...

sql sql-server t-sql rounding

How to use SET XACT_ABORT ON the right way...

sql-server t-sql try-catch rollback xact-abort

Find if any row parameter value was equal to 1 in period of time...

sql sql-server t-sql

How to best write a TSQL script to create or alter a stored procedure that has a table-value type as...

sql-server t-sql sql-server-2022

How to get identity of another table record inside after insert trigger caused by a transaction for ...

sql-server t-sql triggers