dstelow notes…

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: