RSS feed [root] /database /weblog /sql



title search:


Fri Jan 22 11:38:24 HKT 2016


(google search) (amazon search)
download zip of files only

Fri Jan 22 11:39:27 HKT 2016 From /weblog/database/sql


There is way to drop the dummy aggregate function in group by -[..]onal-dependencies-a-very-useful-feature/

(google search) (amazon search)

Mon Jan 13 12:24:11 HKT 2014 From /weblog/database/sql

Problem of SQL

A nice article to talk about problem of SQL. Although we probably need to live with SQL or abstraction of SQL (various OQL and ORM QL), it still nice to know about this

How to simulate column reuse, which is missing from standard SQL -[..]/the-sql-languages-most-missing-feature/

(google search) (amazon search)

Fri May 31 17:55:35 HKT 2013 From /weblog/database/sql


With IN and subquery / or "top" like keywords -[..]econd-highest-or-maximum-salary-sql.html

(google search) (amazon search)

Fri Apr 29 14:41:53 HKT 2011 From /weblog/database/sql


Function that convert string to timestamp for mssql, oracle and sybase -[..]ql-server-basics-todate-function-in.html

(google search) (amazon search)

Tue Jan 11 08:46:00 HKT 2011 From /weblog/database/sql


manipulate xml in sql server -

(google search) (amazon search)

Sat Mar 21 18:54:47 HKT 2009 From /weblog/database/sql


example of except keyword -[..]rence-between-two-sets-of-like-data.aspx

(google search) (amazon search)

Mon Oct 15 19:32:55 HKT 2007 From /weblog/database/sql

ansi joining

A nice article about standard ANSI joining syntax:

Recognizing well known patterns involving outer joins will form a ground-level vocabulary for your further explorations of your data. This article examined syntax, surprises, and rules of thumb with respect to the usage of joins.

A blog with nice graphic show how join work -

(google search) (amazon search)

Wed Jun 13 23:34:34 HKT 2007 From /weblog/database/sql

solve sudoku in sql

A very complicate TSQL sample... in my opinions:

Even more implementation -

which introduce some interesting function in vendor specific SQL, like Oracle MODEL -[..]erver.102/b14223/sqlmodel.htm#sthref1855

(google search) (amazon search)