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

Database

 
AnswerRe: insert new row in sql server Pin
yaad fridman28-Nov-07 20:51
yaad fridman28-Nov-07 20:51 
GeneralRe: insert new row in sql server Pin
break_day28-Nov-07 21:13
break_day28-Nov-07 21:13 
GeneralRe: insert new row in sql server Pin
yaad fridman28-Nov-07 21:40
yaad fridman28-Nov-07 21:40 
GeneralRe: insert new row in sql server Pin
break_day28-Nov-07 23:01
break_day28-Nov-07 23:01 
GeneralRe: insert new row in sql server Pin
yaad fridman1-Dec-07 19:58
yaad fridman1-Dec-07 19:58 
AnswerRe: insert new row in sql server Pin
ChandraRam28-Nov-07 21:19
ChandraRam28-Nov-07 21:19 
QuestionExport Table to Xml Using Sql Pin
Nagaraju_Focus28-Nov-07 20:09
Nagaraju_Focus28-Nov-07 20:09 
AnswerRe: Export Table to Xml Using Sql Pin
Maharishi Bhatia28-Nov-07 20:56
Maharishi Bhatia28-Nov-07 20:56 
In MS SQL Server 2000 there is a "FOR" clause which you can use to retrive the select query result in xml. Basic syntax is as follows,
<br />
FOR XML mode [, XMLDATA] [, ELEMENTS][, BINARY BASE64]<br />
<br />
Arguments<br />
XML mode<br />
<br />
Specifies the XML mode. XML mode determines the shape of the resulting XML. <br />
mode can be RAW, AUTO, or EXPLICIT.<br />
<br />
XMLDATA<br />
<br />
Specifies that an XML-Data schema should be returned. The schema is prepended to the document as an inline schema.<br />
<br />
ELEMENTS<br />
<br />
If the ELEMENTS option is specified, the columns are returned as subelements. Otherwise, they are mapped to XML attributes. This option is supported in AUTO mode only.<br />
<br />
BINARY BASE64<br />
<br />
If the BINARY Base64 option is specified, any binary data returned by the query is represented in base64-encoded format. To retrieve binary data using RAW and EXPLICIT mode, this option must be specified. In AUTO mode, binary data is returned as a reference by default.<br />

Example : Select * from TableName for xml auto

You can search the SQL transact help for further details.

Nothing is Impossible. Even impossible spells "i m possible"

GeneralRe: Export Table to Xml Using Sql Pin
Nagaraju_Focus28-Nov-07 22:23
Nagaraju_Focus28-Nov-07 22:23 
GeneralRe: Export Table to Xml Using Sql Pin
Tobias Schoenig29-Nov-07 1:58
Tobias Schoenig29-Nov-07 1:58 
AnswerRe: Export Table to Xml Using Sql Pin
Maharishi Bhatia1-Dec-07 16:35
Maharishi Bhatia1-Dec-07 16:35 
Questionremote database accessing Pin
dayya28-Nov-07 18:18
dayya28-Nov-07 18:18 
AnswerRe: remote database accessing Pin
pmarfleet28-Nov-07 19:45
pmarfleet28-Nov-07 19:45 
AnswerRe: remote database accessing Pin
Paul Conrad29-Nov-07 13:00
professionalPaul Conrad29-Nov-07 13:00 
QuestionGet size of a table row Pin
Soumya Mathew28-Nov-07 18:10
Soumya Mathew28-Nov-07 18:10 
AnswerRe: Get size of a table row Pin
ChandraRam28-Nov-07 21:27
ChandraRam28-Nov-07 21:27 
AnswerRe: Get size of a table row Pin
Frank Kerrigan30-Nov-07 0:18
Frank Kerrigan30-Nov-07 0:18 
QuestionWhat will happen when more than one click same querry on networking [modified] Pin
r_mohd28-Nov-07 18:09
r_mohd28-Nov-07 18:09 
AnswerRe: What will happen when more than one click same querry on networking Pin
pmarfleet28-Nov-07 19:44
pmarfleet28-Nov-07 19:44 
JokeRe: What will happen when more than one click same querry on networking Pin
ChandraRam28-Nov-07 20:23
ChandraRam28-Nov-07 20:23 
GeneralRe: What will happen when more than one click same querry on networking Pin
pmarfleet29-Nov-07 3:11
pmarfleet29-Nov-07 3:11 
GeneralRe: What will happen when more than one click same querry on networking Pin
ChandraRam29-Nov-07 3:21
ChandraRam29-Nov-07 3:21 
QuestionReading A CSV Then Writing To Oracle Database Pin
cd0428-Nov-07 7:31
cd0428-Nov-07 7:31 
AnswerRe: Reading A CSV Then Writing To Oracle Database Pin
Frank Kerrigan30-Nov-07 0:23
Frank Kerrigan30-Nov-07 0:23 
GeneralRe: Reading A CSV Then Writing To Oracle Database Pin
cd0430-Nov-07 4:00
cd0430-Nov-07 4:00 

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.