dstelow notes…

Archive for August 2009

links for 2009-08-30

leave a comment »

Written by dstelow

August 30, 2009 at 11:02 pm

Posted in 1

links for 2009-08-27

leave a comment »

Written by dstelow

August 27, 2009 at 11:02 pm

Posted in 1

links for 2009-08-26

leave a comment »

Written by dstelow

August 26, 2009 at 11:02 pm

Posted in 1

links for 2009-08-25

leave a comment »

Written by dstelow

August 25, 2009 at 11:03 pm

Posted in 1

links for 2009-08-24

leave a comment »

Written by dstelow

August 24, 2009 at 11:01 pm

Posted in 1

links for 2009-08-20

leave a comment »

  • The SELECT list is interpreted and evaluated last, so there is no way to use an alias defined there in other clauses of the statement. (One exception is the ORDER BY clause, which is not a T-SQL clause, but rather a cursor operator.)
    Joe Celko says the following about the order of operations in a SELECT statement:…
    (tags: database sql tips)

Written by dstelow

August 20, 2009 at 11:03 pm

Posted in 1

links for 2009-08-18

leave a comment »

  • This is a simple but elegant pattern match macro. It works like case, but allows you to match against patterns. These can destructure lists and pairs by binding their elements to variables, and can also contain tests against literals, type tests, and calls to arbitrary predicates in the patterns. The matcher should be easy to extend: it works by converting patterns into boolean functions which may, as a side effect, bind variables declared in the patterns.
    (tags: dev lisp scheme)

Written by dstelow

August 18, 2009 at 11:02 pm

Posted in 1