Wrox Programmer Forums
|
BOOK: Beginning SQL Server 2005 Programming ISBN: 978-0-7645-8433-6
This is the forum to discuss the Wrox book Beginning SQL Server 2005 Programming by Robert Vieira; ISBN: 9780764584336
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning SQL Server 2005 Programming ISBN: 978-0-7645-8433-6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 24th, 2007, 10:52 AM
Authorized User
 
Join Date: Dec 2006
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
Default Page 191 - Alias w/out quotes

Why are there no quotes on P. 191 on the alias for the
MIN((OrderDate)) AS OrderDate?

I was putting single quotes around it like other aliases (AS 'OrderDate'), and needless to say, it wasn't working.

Also, why use two sets of parenthesis on MIN((OrderDate))?

Thanks


Sincerely,
Brian
__________________
Sincerely,
Brian
 
Old June 17th, 2007, 09:03 PM
Registered User
 
Join Date: Jun 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quotes are required for aliases only when they contain spaces. On pages 188-189, spaces were used for the "Store ID" and "Store Name" aliases. "OrderDate" has no such space and needs no quotes.

The double parenthesis around the MIN() function is overkill. Good eye.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Example on p. 191 does not work. mark4asp BOOK: Professional Ajax 2nd Edition ISBN: 978-0-470-10949-6 1 November 1st, 2007 01:40 PM
Chapter 6 page 191 number 6 tgregory BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 8 April 30th, 2007 05:34 PM
displaying single quotes and double quotes ren_123 Classic ASP Databases 2 February 22nd, 2006 02:17 PM
Double Quotes and Single Quotes Problem phungleon Classic ASP Basics 7 May 27th, 2004 01:44 PM
Using quotes in VBSCript and an asp page dragonfields Classic ASP Basics 2 July 31st, 2003 10:30 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.