Click here to Skip to main content
       

Database

 
AnswerRe: jdbc PinmvpRichard MacCutchan15-Feb-13 22:31 
AnswerRe: jdbc PinmemberMycroft Holmes16-Feb-13 15:21 
QuestionOlder generation SQL syntax - Oracle Pinmembervanikanc13-Feb-13 2:37 
AnswerRe: Older generation SQL syntax - Oracle PinmemberJörgen Andersson13-Feb-13 10:30 
GeneralRe: Older generation SQL syntax - Oracle Pinmembervanikanc13-Feb-13 10:37 
AnswerRe: Older generation SQL syntax - Oracle PinmemberShameel15-Feb-13 4:17 
QuestionHaving a bad SQL day PinmemberTheComputerMan12-Feb-13 23:40 
AnswerRe: Having a bad SQL day PinmemberJörgen Andersson13-Feb-13 0:20 
Well, [dkm] is an Alias, not a columnname.
 
You would need to have the same expression in the having or where clause as you have in the select clause.
"The ones who care enough to do it right care too much to compromise."
Matthew Faithfull

GeneralRe: Having a bad SQL day PinmemberTheComputerMan13-Feb-13 0:32 
GeneralRe: Having a bad SQL day [modified] PinmemberJörgen Andersson13-Feb-13 0:40 
GeneralRe: Having a bad SQL day PinmemberBernhard Hiller13-Feb-13 3:24 
GeneralRe: Having a bad SQL day PinmemberTheComputerMan13-Feb-13 3:33 
AnswerRe: Having a bad SQL day PinmemberShameel13-Feb-13 0:53 
GeneralRe: Having a bad SQL day PinmemberJörgen Andersson13-Feb-13 0:56 
GeneralRe: Having a bad SQL day PinmemberPIEBALDconsult13-Feb-13 4:01 
GeneralRe: Having a bad SQL day PinmemberJörgen Andersson13-Feb-13 6:27 
QuestionWhat is Ado.net PinmemberHimanshu Sharma 88812-Feb-13 19:20 
AnswerRe: What is Ado.net PinmvpRichard MacCutchan12-Feb-13 22:31 
GeneralRe: What is Ado.net PinmemberShameel13-Feb-13 0:44 
GeneralRe: What is Ado.net PinmemberThomas Gabriel20-Feb-13 22:42 
AnswerRe: What is Ado.net PinmvpSandeep Mewara13-Feb-13 0:23 
QuestionSQL 2008 Truncate vs Delete Pinmembermrfalk12-Feb-13 6:47 
AnswerRe: SQL 2008 Truncate vs Delete PinmvpEddy Vluggen12-Feb-13 7:48 
GeneralRe: SQL 2008 Truncate vs Delete Pinmembermrfalk12-Feb-13 8:27 
GeneralRe: SQL 2008 Truncate vs Delete PinmvpEddy Vluggen12-Feb-13 8:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.140415.2 | Last Updated 17 Apr 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid