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

time

Function that convert string to timestamp for mssql, oracle and sybase - http://connectsql.blogspot.com[..]ql-server-basics-todate-function-in.html

(google search) (amazon search)

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

xml

manipulate xml in sql server - http://www.15seconds.com/issue/050803.htm

(google search) (amazon search)

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

except

example of except keyword - http://sqlblog.com[..]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:

http://www.oracle.com/technology/oramag/oracle/01-nov/o61sql.html

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.

http://www.onjava.com/lpt/a/4443

A blog with nice graphic show how join work - http://www.codinghorror.com/blog/archives/000976.html

(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: http://www.vsj.co.uk/articles/display.asp?id=540

Even more implementation - http://lambda-the-ultimate.org/node/2291

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

(google search) (amazon search)

Fri Nov 18 12:55:04 HKT 2005 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

http://www.oreillynet.com/lpt/a/6060

(google search) (amazon search)