Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in 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

Try to select null as columnName with table alias

sql sql-server t-sql

Get correct week number for december 31st

sql-server t-sql

Indexed view with data for the last two weeks

TSQL Create trigger with transaction and try catch block

Multi-Level parent-child relationship

sql sql-server t-sql