Click here to Skip to main content
15,907,001 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to write SQL connectionString on web.config file using c#? Pin
Paul Conrad27-Jul-08 19:49
professionalPaul Conrad27-Jul-08 19:49 
QuestionHow can I open and write to txt files in a SQL stored procedure? Pin
alexyxj27-Jul-08 17:02
alexyxj27-Jul-08 17:02 
AnswerRe: How can I open and write to txt files in a SQL stored procedure? Pin
Wendelius27-Jul-08 18:48
mentorWendelius27-Jul-08 18:48 
AnswerRe: How can I open and write to txt files in a SQL stored procedure? Pin
TheFM23428-Jul-08 5:56
TheFM23428-Jul-08 5:56 
QuestionHelp with OpenXML Pin
David Mujica27-Jul-08 10:09
David Mujica27-Jul-08 10:09 
AnswerRe: Help with OpenXML Pin
Wendelius27-Jul-08 10:50
mentorWendelius27-Jul-08 10:50 
GeneralRe: I should have been more specific Pin
David Mujica27-Jul-08 14:40
David Mujica27-Jul-08 14:40 
GeneralRe: I should have been more specific Pin
Wendelius27-Jul-08 18:27
mentorWendelius27-Jul-08 18:27 
No problem Smile | :)

One way is to use SQL to manipulate results. For example:
SELECT set1.localname, set2.text
FROM OPENXML (@idoc, '/DATAMATRIX/FSDATAMATRIX',1) set1
     INNER JOIN 
     OPENXML (@idoc, '/DATAMATRIX/FSDATAMATRIX',1) set2
     ON set1.id = set2.parentid
WHERE set1.LocalName = 'FIELD1'

Remember that you can define the columns you need from the xml by using WITH clause.

Of course if you can modify the XML, you could set the texts as attributes instead of elements, which could simplify your code.

Hope this helps,

Mika
AnswerRe: Help with OpenXML Pin
leoinfo28-Jul-08 2:21
leoinfo28-Jul-08 2:21 
AnswerNow I need to Insert / Update the XML data Pin
David Mujica28-Jul-08 6:10
David Mujica28-Jul-08 6:10 
GeneralRe: Now I need to Insert / Update the XML data Pin
Wendelius28-Jul-08 7:09
mentorWendelius28-Jul-08 7:09 
QuestionError :Failed to connect to server Pin
sunil goyalG27-Jul-08 2:16
sunil goyalG27-Jul-08 2:16 
AnswerRe: Error :Failed to connect to server Pin
Paul Conrad27-Jul-08 5:57
professionalPaul Conrad27-Jul-08 5:57 
QuestionBackup and restore of SQL Server database Pin
sunil goyalG26-Jul-08 0:07
sunil goyalG26-Jul-08 0:07 
AnswerRe: Backup and restore of SQL Server database Pin
Parwej Ahamad26-Jul-08 6:55
professionalParwej Ahamad26-Jul-08 6:55 
AnswerRe: Backup and restore of SQL Server database Pin
Mycroft Holmes26-Jul-08 14:22
professionalMycroft Holmes26-Jul-08 14:22 
QuestionGet SQL server Name Pin
sunil goyalG25-Jul-08 22:03
sunil goyalG25-Jul-08 22:03 
AnswerRe: Get SQL server Name Pin
Mycroft Holmes25-Jul-08 22:52
professionalMycroft Holmes25-Jul-08 22:52 
GeneralRe: Get SQL server Name Pin
sunil goyalG25-Jul-08 23:16
sunil goyalG25-Jul-08 23:16 
GeneralRe: Get SQL server Name Pin
Mycroft Holmes25-Jul-08 23:25
professionalMycroft Holmes25-Jul-08 23:25 
GeneralRe: Get SQL server Name Pin
sunil goyalG25-Jul-08 23:56
sunil goyalG25-Jul-08 23:56 
GeneralRe: Get SQL server Name Pin
BhadeliaImran26-Jul-08 1:39
BhadeliaImran26-Jul-08 1:39 
GeneralRe: Get SQL server Name Pin
Paul Conrad26-Jul-08 14:58
professionalPaul Conrad26-Jul-08 14:58 
GeneralRe: Get SQL server Name Pin
Mycroft Holmes26-Jul-08 15:04
professionalMycroft Holmes26-Jul-08 15:04 
GeneralRe: Get SQL server Name Pin
Paul Conrad26-Jul-08 15:06
professionalPaul Conrad26-Jul-08 15:06 

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.