Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in t-sql

Flattening Hierarchy series using SQL Server CTE

Append SQL table name with today's date

sql-server t-sql

Why SELECT 'A' WHERE @val IN (1, 2, 3, NULL) does not return a value when @val IS NULL? [duplicate]

sql-server t-sql

T-SQL truncate time (not round) to the nearest minute

sql-server t-sql

Why does ROW_NUMBER OVER (ORDER BY column) return a different result order than just ORDER BY column?

help translate this week query from Oracle PL/SQL to SQL Server 2008

Output key value pairs as JSON from T-SQL query

json t-sql

Query where two columns are in the result of nested query

SQL Server optimistic locking - Returning changed timestamp value

Is there a way to make SELECT that fails not throw inside a TRY/CATCH?

Where Not Exists With One to Many Relationship

SELECT MAX Date T-SQL Subquery

sql sql-server t-sql subquery

What does the & symbol mean in this TSQL query?

sql sql-server t-sql rightfax

How to return the table name used out of a delete statement?

sql sql-server t-sql

How to extract data from table2 which is closest to the DATE FIELD of table1?

Single Line IF in T-SQL

Aggregate sql resultset into HashBytes value

sql sql-server t-sql