Click here to Skip to main content
11,704,768 members (50,060 online)
   

Database

 
Questionjdbc Pin
Durgesh1704r15-Feb-13 20:24
memberDurgesh1704r15-Feb-13 20:24 
AnswerRe: jdbc Pin
Richard MacCutchan15-Feb-13 22:31
mvpRichard MacCutchan15-Feb-13 22:31 
AnswerRe: jdbc Pin
Mycroft Holmes16-Feb-13 15:21
memberMycroft Holmes16-Feb-13 15:21 
QuestionOlder generation SQL syntax - Oracle Pin
vanikanc13-Feb-13 2:37
membervanikanc13-Feb-13 2:37 
AnswerRe: Older generation SQL syntax - Oracle Pin
Jörgen Andersson13-Feb-13 10:30
memberJörgen Andersson13-Feb-13 10:30 
GeneralRe: Older generation SQL syntax - Oracle Pin
vanikanc13-Feb-13 10:37
membervanikanc13-Feb-13 10:37 
AnswerRe: Older generation SQL syntax - Oracle Pin
Shameel15-Feb-13 4:17
memberShameel15-Feb-13 4:17 
QuestionHaving a bad SQL day Pin
TheComputerMan12-Feb-13 23:40
memberTheComputerMan12-Feb-13 23:40 
AnswerRe: Having a bad SQL day Pin
Jörgen Andersson13-Feb-13 0:20
memberJörgen Andersson13-Feb-13 0:20 
GeneralRe: Having a bad SQL day Pin
TheComputerMan13-Feb-13 0:32
memberTheComputerMan13-Feb-13 0:32 
GeneralRe: Having a bad SQL day Pin
Jörgen Andersson13-Feb-13 0:40
memberJörgen Andersson13-Feb-13 0:40 
GeneralRe: Having a bad SQL day Pin
Bernhard Hiller13-Feb-13 3:24
memberBernhard Hiller13-Feb-13 3:24 
GeneralRe: Having a bad SQL day Pin
TheComputerMan13-Feb-13 3:33
memberTheComputerMan13-Feb-13 3:33 
AnswerRe: Having a bad SQL day Pin
Shameel13-Feb-13 0:53
memberShameel13-Feb-13 0:53 
To add to Jorgen's answer, I've always wondered why SQL Server doesn't allow us to use alias in WHERE and HAVING clauses. The answer to that lies in the logical order in which the query is processed. The WHERE and HAVING clauses are processed before the SELECT clause and the alias do not exist at that stage.

However, technically it should be possible to introduce another stage earlier in the query processing pipeline where a mapping between expressions and their alias is made and WHERE and HAVING clauses can look up to these mappings and substitute the actual expression in place of the alias.
GeneralRe: Having a bad SQL day Pin
Jörgen Andersson13-Feb-13 0:56
memberJörgen Andersson13-Feb-13 0:56 
GeneralRe: Having a bad SQL day Pin
PIEBALDconsult13-Feb-13 4:01
memberPIEBALDconsult13-Feb-13 4:01 
GeneralRe: Having a bad SQL day Pin
Jörgen Andersson13-Feb-13 6:27
memberJörgen Andersson13-Feb-13 6:27 
QuestionWhat is Ado.net Pin
Himanshu Sharma 88812-Feb-13 19:20
memberHimanshu Sharma 88812-Feb-13 19:20 
AnswerRe: What is Ado.net Pin
Richard MacCutchan12-Feb-13 22:31
mvpRichard MacCutchan12-Feb-13 22:31 
GeneralRe: What is Ado.net Pin
Shameel13-Feb-13 0:44
memberShameel13-Feb-13 0:44 
GeneralRe: What is Ado.net Pin
Thomas Gabriel20-Feb-13 22:42
memberThomas Gabriel20-Feb-13 22:42 
AnswerRe: What is Ado.net Pin
Sandeep Mewara13-Feb-13 0:23
mvpSandeep Mewara13-Feb-13 0:23 
QuestionSQL 2008 Truncate vs Delete Pin
mrfalk12-Feb-13 6:47
membermrfalk12-Feb-13 6:47 
AnswerRe: SQL 2008 Truncate vs Delete Pin
Eddy Vluggen12-Feb-13 7:48
mvpEddy Vluggen12-Feb-13 7:48 
GeneralRe: SQL 2008 Truncate vs Delete Pin
mrfalk12-Feb-13 8:27
membermrfalk12-Feb-13 8:27 
GeneralRe: SQL 2008 Truncate vs Delete Pin
Eddy Vluggen12-Feb-13 8:36
mvpEddy Vluggen12-Feb-13 8:36 
GeneralRe: SQL 2008 Truncate vs Delete Pin
Khorshed Alam, Dhaka18-Feb-13 18:09
memberKhorshed Alam, Dhaka18-Feb-13 18:09 
AnswerRe: SQL 2008 Truncate vs Delete Pin
NickPace12-Feb-13 10:09
memberNickPace12-Feb-13 10:09 
AnswerRe: SQL 2008 Truncate vs Delete Pin
djj5513-Feb-13 3:59
memberdjj5513-Feb-13 3:59 
AnswerRe: SQL 2008 Truncate vs Delete Pin
gvprabu20-Feb-13 21:37
membergvprabu20-Feb-13 21:37 
QuestionSQL Server 2008 Pin
VishwaKL10-Feb-13 17:51
memberVishwaKL10-Feb-13 17:51 
AnswerRe: SQL Server 2008 Pin
Shameel10-Feb-13 22:33
memberShameel10-Feb-13 22:33 
AnswerRe: SQL Server 2008 Pin
jschell11-Feb-13 8:20
memberjschell11-Feb-13 8:20 
Questionupdate values in a table in single query Pin
nainakarri7-Feb-13 20:07
membernainakarri7-Feb-13 20:07 
AnswerRe: update values in a table in single query Pin
Mycroft Holmes7-Feb-13 21:00
memberMycroft Holmes7-Feb-13 21:00 
GeneralRe: update values in a table in single query Pin
Shameel10-Feb-13 22:38
memberShameel10-Feb-13 22:38 
GeneralRe: update values in a table in single query Pin
Mycroft Holmes11-Feb-13 13:30
memberMycroft Holmes11-Feb-13 13:30 
AnswerRe: update values in a table in single query Pin
Eddy Vluggen7-Feb-13 22:42
mvpEddy Vluggen7-Feb-13 22:42 
GeneralRe: update values in a table in single query Pin
gvprabu10-Feb-13 18:02
membergvprabu10-Feb-13 18:02 
AnswerRe: update values in a table in single query Pin
gvprabu20-Feb-13 21:43
membergvprabu20-Feb-13 21:43 
QuestionIs it possible to print a variable in stored procedure Pin
Deepthi.214567-Feb-13 19:45
memberDeepthi.214567-Feb-13 19:45 
AnswerRe: Is it possible to print a variable in stored procedure Pin
nainakarri7-Feb-13 20:22
membernainakarri7-Feb-13 20:22 
GeneralRe: Is it possible to print a variable in stored procedure Pin
vanikanc12-Feb-13 8:19
membervanikanc12-Feb-13 8:19 
QuestionVisual Studio 2005 Access 2010 Database Pin
Member 98194707-Feb-13 12:06
memberMember 98194707-Feb-13 12:06 
AnswerRe: Visual Studio 2005 Access 2010 Database Pin
Mycroft Holmes7-Feb-13 13:45
memberMycroft Holmes7-Feb-13 13:45 
QuestionSimulate transaction: non blocking insert / update Pin
Bob Stanneveld7-Feb-13 11:12
memberBob Stanneveld7-Feb-13 11:12 
AnswerRe: Simulate transaction: non blocking insert / update Pin
Mycroft Holmes7-Feb-13 13:44
memberMycroft Holmes7-Feb-13 13:44 
QuestionPropagating a MySQL transaction with MSMQ II Pin
Ger Hayden6-Feb-13 8:08
memberGer Hayden6-Feb-13 8:08 
QuestionMissing Data in an Access Report Pin
Vuyiswa Maseko6-Feb-13 3:03
memberVuyiswa Maseko6-Feb-13 3:03 
AnswerRe: Missing Data in an Access Report Pin
jschell6-Feb-13 8:11
memberjschell6-Feb-13 8:11 

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