Click here to Skip to main content
15,501,984 members
Home / Discussions / Database
   

Database

 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
GuyThiebaut14-Jul-14 22:33
professionalGuyThiebaut14-Jul-14 22:33 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Ambertje14-Jul-14 23:13
MemberAmbertje14-Jul-14 23:13 
QuestionError: Can't delete row or update row in SQL Server ? Pin
taibc11-Jul-14 19:29
Membertaibc11-Jul-14 19:29 
AnswerRe: Error: Can't delete row or update row in SQL Server ? Pin
Mycroft Holmes12-Jul-14 0:32
professionalMycroft Holmes12-Jul-14 0:32 
GeneralRe: Error: Can't delete row or update row in SQL Server ? Pin
taibc13-Jul-14 21:36
Membertaibc13-Jul-14 21:36 
GeneralRe: Error: Can't delete row or update row in SQL Server ? Pin
Mycroft Holmes13-Jul-14 22:06
professionalMycroft Holmes13-Jul-14 22:06 
AnswerRe: Error: Can't delete row or update row in SQL Server ? Pin
ZurdoDev14-Jul-14 11:14
professionalZurdoDev14-Jul-14 11:14 
QuestionJOIN vs. WHERE Pin
Klaus-Werner Konrad11-Jul-14 10:22
MemberKlaus-Werner Konrad11-Jul-14 10:22 
I quite don't understand why noone is using the WHERE-Syntax for table joining ...

I always see something like
SQL
SELECT  O.Order_No, C.Address, F.Address 
FROM    Orders O
JOIN    Address C
    ON  O.Customer = C.ID
JOIN    Address F 
    ON  O.Forwarder = C.ID

For me, the most irritating thig is the spreading of table names and aliases all over the Statement.

I prefer
SQL
SELECT O.Order_No, C.Address, F.Address
FROM Orders O, Address C, Address F 
WHERE O.Customer = C.ID 
AND O.Forwarder = F.ID

- It's shorter
- All table names and aliases are together

Arguments, anyone ?
AnswerRe: JOIN vs. WHERE Pin
Mycroft Holmes11-Jul-14 15:24
professionalMycroft Holmes11-Jul-14 15:24 
GeneralRe: JOIN vs. WHERE Pin
Klaus-Werner Konrad12-Jul-14 10:08
MemberKlaus-Werner Konrad12-Jul-14 10:08 
GeneralRe: JOIN vs. WHERE Pin
Mycroft Holmes12-Jul-14 15:13
professionalMycroft Holmes12-Jul-14 15:13 
GeneralRe: JOIN vs. WHERE Pin
Klaus-Werner Konrad13-Jul-14 1:08
MemberKlaus-Werner Konrad13-Jul-14 1:08 
AnswerRe: JOIN vs. WHERE Pin
data modeling guy11-Jul-14 20:53
Memberdata modeling guy11-Jul-14 20:53 
GeneralRe: JOIN vs. WHERE Pin
Mycroft Holmes12-Jul-14 0:29
professionalMycroft Holmes12-Jul-14 0:29 
GeneralRe: JOIN vs. WHERE Pin
Jörgen Andersson12-Jul-14 10:42
professionalJörgen Andersson12-Jul-14 10:42 
AnswerRe: JOIN vs. WHERE Pin
Jörgen Andersson12-Jul-14 11:25
professionalJörgen Andersson12-Jul-14 11:25 
GeneralRe: JOIN vs. WHERE Pin
Mycroft Holmes12-Jul-14 15:22
professionalMycroft Holmes12-Jul-14 15:22 
GeneralRe: JOIN vs. WHERE Pin
Jörgen Andersson12-Jul-14 21:44
professionalJörgen Andersson12-Jul-14 21:44 
GeneralRe: JOIN vs. WHERE Pin
Jörgen Andersson12-Jul-14 21:55
professionalJörgen Andersson12-Jul-14 21:55 
GeneralRe: JOIN vs. WHERE Pin
Klaus-Werner Konrad13-Jul-14 1:35
MemberKlaus-Werner Konrad13-Jul-14 1:35 
GeneralRe: JOIN vs. WHERE Pin
Jörgen Andersson13-Jul-14 2:09
professionalJörgen Andersson13-Jul-14 2:09 
GeneralRe: JOIN vs. WHERE Pin
data modeling guy13-Jul-14 6:57
Memberdata modeling guy13-Jul-14 6:57 
GeneralRe: JOIN vs. WHERE Pin
Klaus-Werner Konrad13-Jul-14 2:08
MemberKlaus-Werner Konrad13-Jul-14 2:08 
GeneralRe: JOIN vs. WHERE Pin
Jörgen Andersson13-Jul-14 2:46
professionalJörgen Andersson13-Jul-14 2:46 
QuestionHow to create an audit table? Pin
Bastien Vandamme10-Jul-14 1:30
MemberBastien Vandamme10-Jul-14 1:30 

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

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