Asked by Lisa
I have created a Database called Business with the 2 tables as follows:
dbo.Orders
ID
OrderID
ItemName
Quantity
Price
SalesID
dbo.Sales
SalesID
FIrstName
LastName
OrderID
I need to create a stored procedure to show all the data from both tables in xml format. How do I do this.
dbo.Orders
ID
OrderID
ItemName
Quantity
Price
SalesID
dbo.Sales
SalesID
FIrstName
LastName
OrderID
I need to create a stored procedure to show all the data from both tables in xml format. How do I do this.
Answers
There are no human answers yet.
There are no AI answers yet. The ability to request AI answers is coming soon!
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.