Click here to Skip to main content
14,147,016 members
   

Database

 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
Mycroft Holmes31-Jan-19 11:15
memberMycroft Holmes31-Jan-19 11:15 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
paul4everyone2-Feb-19 19:03
memberpaul4everyone2-Feb-19 19:03 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
Mycroft Holmes2-Feb-19 19:29
memberMycroft Holmes2-Feb-19 19:29 
Questionis it safe to use this with sql server and entity framework ? Pin
desanti9-Jan-19 14:38
memberdesanti9-Jan-19 14:38 
AnswerRe: is it safe to use this with sql server and entity framework ? Pin
Mycroft Holmes9-Jan-19 19:51
memberMycroft Holmes9-Jan-19 19:51 
Yes but your table design sucks try.

Customer
CustomerID
Name
City

Order
OrderID
CustomerID
Sender
Receiver

This assumes that the customer only ever lives in 1 city and never moves.

Take a look at some of these database structures and see if one will work for you.
http://www.databaseanswers.org/data_models/[^]
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

AnswerRe: is it safe to use this with sql server and entity framework ? Pin
Eddy Vluggen10-Jan-19 2:17
mveEddy Vluggen10-Jan-19 2:17 
QuestionGetting error in SQL 2012 working fine in 2016 Pin
GaneshVidiyala25-Dec-18 21:41
professionalGaneshVidiyala25-Dec-18 21:41 
AnswerRe: Getting error in SQL 2012 working fine in 2016 Pin
jschell27-Dec-18 13:34
memberjschell27-Dec-18 13:34 
Questionssrs An attempt has been made to use a data extension 'ORACLE' error Pin
anjel8425-Dec-18 20:34
memberanjel8425-Dec-18 20:34 
AnswerRe: ssrs An attempt has been made to use a data extension 'ORACLE' error Pin
rnbergren24-Jan-19 8:24
memberrnbergren24-Jan-19 8:24 
QuestionCan't Insert data into Access Table from Python - Solved Pin
Peter R. Fletcher5-Dec-18 15:16
memberPeter R. Fletcher5-Dec-18 15:16 
AnswerRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan5-Dec-18 22:19
protectorRichard MacCutchan5-Dec-18 22:19 
GeneralRe: Can't Insert data into Access Table from Python Pin
Victor Nijegorodov6-Dec-18 1:09
memberVictor Nijegorodov6-Dec-18 1:09 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan6-Dec-18 1:21
protectorRichard MacCutchan6-Dec-18 1:21 
GeneralRe: Can't Insert data into Access Table from Python Pin
Peter R. Fletcher6-Dec-18 2:11
memberPeter R. Fletcher6-Dec-18 2:11 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan6-Dec-18 3:16
protectorRichard MacCutchan6-Dec-18 3:16 
GeneralRe: Can't Insert data into Access Table from Python Pin
Peter R. Fletcher6-Dec-18 4:37
memberPeter R. Fletcher6-Dec-18 4:37 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan6-Dec-18 5:11
protectorRichard MacCutchan6-Dec-18 5:11 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan8-Dec-18 4:46
protectorRichard MacCutchan8-Dec-18 4:46 
GeneralRe: Can't Insert data into Access Table from Python Pin
Peter R. Fletcher8-Dec-18 5:04
memberPeter R. Fletcher8-Dec-18 5:04 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan8-Dec-18 5:58
protectorRichard MacCutchan8-Dec-18 5:58 
GeneralRe: Can't Insert data into Access Table from Python Pin
Peter R. Fletcher8-Dec-18 7:36
memberPeter R. Fletcher8-Dec-18 7:36 
GeneralRe: Can't Insert data into Access Table from Python Pin
Mycroft Holmes8-Dec-18 11:52
memberMycroft Holmes8-Dec-18 11:52 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan8-Dec-18 21:09
protectorRichard MacCutchan8-Dec-18 21:09 
QuestionError reading data from SQL Server ? Pin
Member 24584673-Dec-18 22:25
memberMember 24584673-Dec-18 22:25 

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.


Advertise | Privacy | Cookies | Terms of Service
Web06 | 2.8.190518.1 | Last Updated 23 May 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid