25.09.2016, 13:06
Yes I know this is not related to sa-mp!
But since I've tried other forums etc with little to no help I'm desperate.
What I need help with is this code:
When I run this code obviously I get 4 .XML files. Is there a way to get the results combined into ONE xml file?
And I'm very very new to this so please point out if I can do this code faster and more efficient in some way.
What I then have to do is take the .xml file into C#, bubble sort it, and transfer it back to a 3rd database.
And at that point I'm compleatly lost..
Again, I know this proberbly doesn't belong here and is a possible rule break but since I know there a good and helpful coders here who can help me understand and get this done I'm willing to risk it.
But since I've tried other forums etc with little to no help I'm desperate.
What I need help with is this code:
PHP код:
SELECT *
FROM [Database1].[dbo].[Table_1]
ORDER BY NEWID()
FOR XML AUTO
SELECT *
FROM [Database1].[dbo].[Table_2]
ORDER BY NEWID()
FOR XML AUTO
SELECT *
FROM [Database2].[dbo].[Table_1]
FOR XML AUTO
SELECT *
FROM [Database2].[dbo].[Table_2]
FOR XML AUTO
And I'm very very new to this so please point out if I can do this code faster and more efficient in some way.
What I then have to do is take the .xml file into C#, bubble sort it, and transfer it back to a 3rd database.
And at that point I'm compleatly lost..
Again, I know this proberbly doesn't belong here and is a possible rule break but since I know there a good and helpful coders here who can help me understand and get this done I'm willing to risk it.