Click here to Skip to main content
15,121,678 members
Home / Discussions / Database
   

Database

 
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 
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
professionalMycroft 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
mveAfzaal 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 
So lets say I have a table (Ports) with an Identifier and then a compacted not XML field that is semi structured.

select * from Ports --Yields this.
ID Categories
1 Town:York, Street:Main, Phone:712-542-3423

The Categories field might have two fields in it. Town and Street or it might have 15.

I need to get these out into separate fields as soo
ID Town Street Phone
1 York Main 712......

ideas on SQL SQL server 2016 is what we are running.

Ideas?
To err is human to really mess up you need a computer

AnswerRe: I didn't design it but I need to get data out of it. Pin
Richard Deeming2-Aug-19 5:51
mveRichard 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
professionalZurdoDev2-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
professionalMycroft 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
mveRichard 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
mveRichard 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 
AnswerRe: Best practices for database tables. Pin
CHill6018-Jul-19 0:17
mveCHill6018-Jul-19 0:17 
AnswerRe: Best practices for database tables. Pin
Mycroft Holmes18-Jul-19 12:57
professionalMycroft Holmes18-Jul-19 12:57 
GeneralRe: Best practices for database tables. Pin
RLD7121-Jul-19 4:37
professionalRLD7121-Jul-19 4:37 
Questionstructure question Pin
Joan M11-Jul-19 2:30
professionalJoan M11-Jul-19 2:30 
AnswerRe: structure question Pin
Eddy Vluggen11-Jul-19 3:01
professionalEddy Vluggen11-Jul-19 3:01 
GeneralRe: structure question Pin
CHill6018-Jul-19 2:30
mveCHill6018-Jul-19 2: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.