RSS feed [root] /database /weblog /sql




login:

password:

title search:




 


Fri Jan 22 11:38:24 HKT 2016

sql



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

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

grouping


There is way to drop the dummy aggregate function in group by - http://blog.jooq.org[..]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

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

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

(google search) (amazon search)


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

join


http://www.codeproject.com[..]33052/Visual-Representation-of-SQL-Joins http://nosql.mypopescu.com/post/51770099382/sql-joins-visualized

With IN and subquery / or "top" like keywords - http://javarevisited.blogspot.com.au[..]econd-highest-or-maximum-salary-sql.html


(google search) (amazon search)


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)