"1" as column name -----Original Message----- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:29 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query?
just in the returned query -----Original Message----- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:31 AM To: CF-Talk Subject: Re: OT (SQL): Add column to query? Do you want it in the table, or just in the returned query? Jerry Johnson >>> [EMAIL PROTECTED] 05/20/02 11:12AM >>> I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1 Col2 Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1 Col2 Col3 myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
