Click here to Skip to main content
   

Database

 
GeneralRe: Dual Primary Key? PinmemberRichard.Berry10021-Feb-13 8:42 
GeneralRe: Dual Primary Key? PinmvpEddy Vluggen21-Feb-13 9:32 
GeneralRe: Dual Primary Key? PinmemberMycroft Holmes21-Feb-13 13:08 
GeneralRe: Dual Primary Key? PinmemberPIEBALDconsult21-Feb-13 19:14 
GeneralRe: Dual Primary Key? PinmvpEddy Vluggen21-Feb-13 23:42 
Questionjdbc PinmemberDurgesh1704r15-Feb-13 21:24 
AnswerRe: jdbc PinmvpRichard MacCutchan15-Feb-13 23:31 
AnswerRe: jdbc PinmemberMycroft Holmes16-Feb-13 16:21 
QuestionOlder generation SQL syntax - Oracle Pinmembervanikanc13-Feb-13 3:37 
AnswerRe: Older generation SQL syntax - Oracle PinmemberJörgen Andersson13-Feb-13 11:30 
GeneralRe: Older generation SQL syntax - Oracle Pinmembervanikanc13-Feb-13 11:37 
AnswerRe: Older generation SQL syntax - Oracle PinmemberShameel15-Feb-13 5:17 
QuestionHaving a bad SQL day PinmemberTheComputerMan13-Feb-13 0:40 
AnswerRe: Having a bad SQL day PinmemberJörgen Andersson13-Feb-13 1: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 1:32 
GeneralRe: Having a bad SQL day [modified] PinmemberJörgen Andersson13-Feb-13 1:40 
GeneralRe: Having a bad SQL day PinmemberBernhard Hiller13-Feb-13 4:24 
GeneralRe: Having a bad SQL day PinmemberTheComputerMan13-Feb-13 4:33 
AnswerRe: Having a bad SQL day PinmemberShameel13-Feb-13 1:53 
GeneralRe: Having a bad SQL day PinmemberJörgen Andersson13-Feb-13 1:56 
GeneralRe: Having a bad SQL day PinmemberPIEBALDconsult13-Feb-13 5:01 
GeneralRe: Having a bad SQL day PinmemberJörgen Andersson13-Feb-13 7:27 
QuestionWhat is Ado.net PinmemberHimanshu Sharma 88812-Feb-13 20:20 
AnswerRe: What is Ado.net PinmvpRichard MacCutchan12-Feb-13 23:31 
GeneralRe: What is Ado.net PinmemberShameel13-Feb-13 1:44 
GeneralRe: What is Ado.net PinmemberThomas Gabriel20-Feb-13 23:42 
AnswerRe: What is Ado.net PinmvpSandeep Mewara13-Feb-13 1:23 
QuestionSQL 2008 Truncate vs Delete Pinmembermrfalk12-Feb-13 7:47 
AnswerRe: SQL 2008 Truncate vs Delete PinmvpEddy Vluggen12-Feb-13 8:48 
GeneralRe: SQL 2008 Truncate vs Delete Pinmembermrfalk12-Feb-13 9:27 
GeneralRe: SQL 2008 Truncate vs Delete PinmvpEddy Vluggen12-Feb-13 9:36 
GeneralRe: SQL 2008 Truncate vs Delete PinmemberKhorshed Alam, Dhaka18-Feb-13 19:09 
AnswerRe: SQL 2008 Truncate vs Delete PinmemberNickPace12-Feb-13 11:09 
AnswerRe: SQL 2008 Truncate vs Delete Pinmemberdjj5513-Feb-13 4:59 
AnswerRe: SQL 2008 Truncate vs Delete Pinmembergvprabu20-Feb-13 22:37 
QuestionSQL Server 2008 PinmemberVishwaKL10-Feb-13 18:51 
AnswerRe: SQL Server 2008 PinmemberShameel10-Feb-13 23:33 
AnswerRe: SQL Server 2008 Pinmemberjschell11-Feb-13 9:20 
Questionupdate values in a table in single query Pinmembernainakarri7-Feb-13 21:07 
AnswerRe: update values in a table in single query PinmemberMycroft Holmes7-Feb-13 22:00 
GeneralRe: update values in a table in single query PinmemberShameel10-Feb-13 23:38 
GeneralRe: update values in a table in single query PinmemberMycroft Holmes11-Feb-13 14:30 
AnswerRe: update values in a table in single query PinmvpEddy Vluggen7-Feb-13 23:42 
GeneralRe: update values in a table in single query Pinmembergvprabu10-Feb-13 19:02 
AnswerRe: update values in a table in single query Pinmembergvprabu20-Feb-13 22:43 
QuestionIs it possible to print a variable in stored procedure PinmemberDeepthi.214567-Feb-13 20:45 
AnswerRe: Is it possible to print a variable in stored procedure Pinmembernainakarri7-Feb-13 21:22 
GeneralRe: Is it possible to print a variable in stored procedure Pinmembervanikanc12-Feb-13 9:19 
QuestionVisual Studio 2005 Access 2010 Database PinmemberMember 98194707-Feb-13 13:06 
AnswerRe: Visual Studio 2005 Access 2010 Database PinmemberMycroft Holmes7-Feb-13 14:45 

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.150123.1 | Last Updated 26 Jan 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid