Click here to Skip to main content
15,882,931 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQL Database Security Pin
Eddy Vluggen22-Jun-13 7:24
professionalEddy Vluggen22-Jun-13 7:24 
AnswerRe: SQL Database Security Pin
Mycroft Holmes22-Jun-13 13:40
professionalMycroft Holmes22-Jun-13 13:40 
Generalmysql or postgresql for Ubuntu + Java trading system? Pin
crunchor21-Jun-13 20:41
crunchor21-Jun-13 20:41 
GeneralRe: mysql or postgresql for Ubuntu + Java trading system? Pin
Rutvik Dave21-Jun-13 21:20
professionalRutvik Dave21-Jun-13 21:20 
GeneralRe: mysql or postgresql for Ubuntu + Java trading system? Pin
Matthew Faithfull21-Jun-13 21:51
Matthew Faithfull21-Jun-13 21:51 
GeneralRe: mysql or postgresql for Ubuntu + Java trading system? Pin
crunchor21-Jun-13 23:56
crunchor21-Jun-13 23:56 
GeneralRe: mysql or postgresql for Ubuntu + Java trading system? Pin
Bernhard Hiller23-Jun-13 21:25
Bernhard Hiller23-Jun-13 21:25 
QuestionGenerating Custom XML from multiple rows in SQL server Pin
ONeil Tomlinson19-Jun-13 5:10
ONeil Tomlinson19-Jun-13 5:10 
I have the following table and i would like to generate an XML as shown below. How do i go about doing this please? All help appreciated. Thanks

XML
id school,    name,  Subject,   results, studentID
----------------------------------------------------------------
1  oxford     tom    Maths      98      1
2  oxford     tom    English    87      1
3  oxford     tom    Chemistry  63      1

4  Cambridge  john   Maths      50      2
5  Cambridge  john   English    72      2
6  Cambridge  john   Chemistry  32      2



<Register>
<Schools>


 <School>
    <Name>Oxford</Name>
    <Students>
       <Student>
          <Name>tom</Name>
          <Subjects>
             <Subject>
                <Name>Maths<Name>
                <grde>98<grde>
             <Subject>
             <Subject>
              <Name>English<Name>
              <grde>87<grde>
             <Subject>
            <Subject>
              <Name>Chemistry<Name>
              <grde>63<grde>
            <Subject>
         <Subjects>
      <Student>
   <Students>
 <School>



 <School>
    <Name>Cambridge</Name>
    <Students>
       <Student>
          <Name>john</Name>
          <Subjects>
             <Subject>
                <Name>Maths<Name>
                <grde>50<grde>
             <Subject>
             <Subject>
              <Name>English<Name>
              <grde>72<grde>
             <Subject>
            <Subject>
              <Name>Chemistry<Name>
              <grde>32<grde>
            <Subject>
         <Subjects>
      <Student>
   <Students>
 <School>


<Schools>
<Register>

AnswerRe: Generating Custom XML from multiple rows in SQL server Pin
Richard MacCutchan19-Jun-13 7:00
mveRichard MacCutchan19-Jun-13 7:00 
AnswerRe: Generating Custom XML from multiple rows in SQL server Pin
RedDk23-Jun-13 9:21
RedDk23-Jun-13 9:21 
QuestionHow to permanently solve (blocked because of many connection0 error? Pin
Jassim Rahma18-Jun-13 2:25
Jassim Rahma18-Jun-13 2:25 
AnswerRe: How to permanently solve (blocked because of many connection0 error? Pin
jschell18-Jun-13 8:40
jschell18-Jun-13 8:40 
AnswerRe: How to permanently solve (blocked because of many connection0 error? Pin
Bernhard Hiller19-Jun-13 21:13
Bernhard Hiller19-Jun-13 21:13 
Questionarabic character not saved in MySQL Pin
Jassim Rahma16-Jun-13 10:20
Jassim Rahma16-Jun-13 10:20 
AnswerRe: arabic character not saved in MySQL Pin
Simon_Whale16-Jun-13 22:32
Simon_Whale16-Jun-13 22:32 
GeneralRe: arabic character not saved in MySQL Pin
Jassim Rahma17-Jun-13 11:27
Jassim Rahma17-Jun-13 11:27 
QuestionDatabase Design For Multiple Product Types Pin
Member 770211015-Jun-13 0:28
Member 770211015-Jun-13 0:28 
AnswerRe: Database Design For Multiple Product Types Pin
Eddy Vluggen15-Jun-13 2:41
professionalEddy Vluggen15-Jun-13 2:41 
AnswerRe: Database Design For Multiple Product Types Pin
David Mujica17-Jun-13 4:08
David Mujica17-Jun-13 4:08 
GeneralRe: Database Design For Multiple Product Types Pin
Jörgen Andersson17-Jun-13 7:19
professionalJörgen Andersson17-Jun-13 7:19 
QuestionCreating New Database in SQL 2012 Management Studio Pin
Gary Heath13-Jun-13 6:41
Gary Heath13-Jun-13 6:41 
AnswerRe: Creating New Database in SQL 2012 Management Studio Pin
Eddy Vluggen13-Jun-13 9:45
professionalEddy Vluggen13-Jun-13 9:45 
GeneralRe: Creating New Database in SQL 2012 Management Studio Pin
Gary Heath13-Jun-13 11:44
Gary Heath13-Jun-13 11:44 
GeneralRe: Creating New Database in SQL 2012 Management Studio Pin
Bram van Kampen14-Jun-13 14:17
Bram van Kampen14-Jun-13 14:17 
GeneralRe: Creating New Database in SQL 2012 Management Studio Pin
Eddy Vluggen15-Jun-13 1:54
professionalEddy Vluggen15-Jun-13 1:54 

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.