Click here to Skip to main content
14,425,800 members
   

Database

 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
jan Meeling19-Aug-19 2:55
Memberjan Meeling19-Aug-19 2:55 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
Eddy Vluggen19-Aug-19 3:03
mveEddy Vluggen19-Aug-19 3:03 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
jan Meeling20-Aug-19 2:02
Memberjan Meeling20-Aug-19 2:02 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
Richard MacCutchan20-Aug-19 5:20
communityengineerRichard MacCutchan20-Aug-19 5:20 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
jan Meeling20-Aug-19 8:39
Memberjan Meeling20-Aug-19 8:39 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
Richard MacCutchan20-Aug-19 22:17
communityengineerRichard MacCutchan20-Aug-19 22:17 
AnswerRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
jan Meeling20-Aug-19 2:03
Memberjan Meeling20-Aug-19 2:03 
QuestionProduct Architecture Pin
Chiranjana13-Aug-19 1:50
MemberChiranjana13-Aug-19 1:50 
I have a product that offers a small lead management system. The architecture of product is simple so far. I have tables called 'companies', 'users', 'leads'. Users within a company have CRUD rights on leads. Now companies want their agents to have rights to operate leads. So we can ask companies to add their agent as a user within the company but there is a problem. Each user needs to have a unique email to register. So if one agent serves 5 companies they can't be added as a user by each of them. What should be the ideal way to handle this.

Thought of having separate database for each company so that problem of unique email is resolved but I'm not sure how to manage multiple databases for updates
AnswerRe: Product Architecture Pin
David Mujica13-Aug-19 4:50
MemberDavid Mujica13-Aug-19 4:50 
GeneralRe: Product Architecture Pin
Chiranjana13-Aug-19 6:05
MemberChiranjana13-Aug-19 6:05 
AnswerRe: Product Architecture Pin
Mycroft Holmes13-Aug-19 13:50
MemberMycroft Holmes13-Aug-19 13:50 
Questioncookies vs sessions for storing users id for ecommerce site Pin
djtrixy2-Aug-19 22:48
Memberdjtrixy2-Aug-19 22:48 
AnswerRe: cookies vs sessions for storing users id for ecommerce site Pin
Afzaal Ahmad Zeeshan3-Aug-19 5:02
mvaAfzaal Ahmad Zeeshan3-Aug-19 5:02 
QuestionI didn't design it but I need to get data out of it. Pin
rnbergren2-Aug-19 5:23
Memberrnbergren2-Aug-19 5:23 
AnswerRe: I didn't design it but I need to get data out of it. Pin
Richard Deeming2-Aug-19 5:51
communityengineerRichard Deeming2-Aug-19 5:51 
GeneralRe: I didn't design it but I need to get data out of it. Pin
rnbergren2-Aug-19 9:12
Memberrnbergren2-Aug-19 9:12 
AnswerRe: I didn't design it but I need to get data out of it. Pin
ZurdoDev2-Aug-19 11:33
mveZurdoDev2-Aug-19 11:33 
AnswerRe: I didn't design it but I need to get data out of it. Pin
Mycroft Holmes2-Aug-19 14:40
MemberMycroft Holmes2-Aug-19 14:40 
QuestionSQL Server: Facing problem to parse xml using xquery Pin
Mou_kol31-Jul-19 6:56
MemberMou_kol31-Jul-19 6:56 
Questionstructure question 2 Pin
Joan M18-Jul-19 22:25
professionalJoan M18-Jul-19 22:25 
AnswerRe: structure question 2 Pin
Richard Deeming19-Jul-19 2:11
communityengineerRichard Deeming19-Jul-19 2:11 
GeneralRe: structure question 2 Pin
Joan M19-Jul-19 2:14
professionalJoan M19-Jul-19 2:14 
GeneralRe: structure question 2 Pin
Richard Deeming19-Jul-19 2:27
communityengineerRichard Deeming19-Jul-19 2:27 
PraiseRe: structure question 2 Pin
Joan M19-Jul-19 2:31
professionalJoan M19-Jul-19 2:31 
QuestionBest practices for database tables. Pin
RLD7114-Jul-19 13:37
professionalRLD7114-Jul-19 13:37 

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.