t-sql Examples and Free Source Code

Sargability of RIGHT/LEFT in SQL...

sql t-sql query-optimization static-analysis

How to drop multiple databases in SQL Server...

database t-sql sql-drop

Extract numeric values out of a nvarchar column in SQL...

sql-server t-sql

Extracting hours from a DateTime (SQL Server 2005)...

sql t-sql datetime sql-server-2005 hour

Adding max(value)+1 in new row, can this be a problem?...

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

SP_EXECUTESQL and Output Parameter...

sql sql-server t-sql stored-procedures

Substitute for STRING_AGG pre SQL Server 2016...

sql-server t-sql group-by string-aggregation

Run stored procedure for each row of a table...

sql t-sql stored-procedures

Generate MD5 hash string with T-SQL...

sql-server t-sql sql-server-2008

T-SQL Throw Exception...

sql-server t-sql throw

How do I escape a single quote in SQL Server?...

sql sql-server t-sql delimiter single-quotes

How can I do something like: USE @databaseName...

sql-server t-sql

SQL Management Studio can't drag table / object from Explorer to Query Editor...

sql sql-server t-sql

NOT EXISTS with multiple criteria and indirect unique id in SQL Server...

sql-server t-sql not-exists

Using multiple statements in WHEN MATCHED...

sql sql-server t-sql merge sql-update

Calculating Absences by hours and days between dates...

sql sql-server t-sql

is it possible to select EXISTS directly as a bit?...

sql sql-server t-sql

OR is not supported with CASE expression SQL Server...

sql sql-server t-sql case

How do you view ALL text from an ntext or nvarchar(max) in SSMS?...

sql-server sql-server-2008 t-sql ssms

How to ignore trailing whitespace?...

c#sql entity-framework t-sql

How to add table column headings to sql select statement...

sql sql-server t-sql header

Syntax of for-loop in SQL Server...

sql sql-server loops t-sql syntax

Simple Way to View SQL Query (ies) Generated by SSRS Reports?...

t-sql sql-server-2008 ssrs-2008

Filling in data as zero which is not existing in database SSRS...

sql-server t-sql reporting-services

Identifier on yearly base...

sql sql-server t-sql window-functions

TSQL - How to URL Encode...

sql sql-server t-sql

Keeping a constant identifying value at the beginning of a recursively unioning cte...

sql-server t-sql hierarchical-data recursive-cte

Databricks SQL Will Not Accept Correlated Columns Error: Correlated column is not allowed in a non-e...

sql sql-server t-sql databricks-sql

How to Insert Data into Table Using SQL Server Table Using INSERT INTO query...

sql sql-server t-sql

SQL Joins returning results from one T-SQL Query but not another...

sql t-sql databricks-sql