Wednesday
August 20, 2014

Homework Help: SQL Server

Posted by Lisa on Wednesday, May 2, 2012 at 4:18pm.

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.

Answer this Question

First Name:
School Subject:
Answer:

Related Questions

programming - I have created a Database called Business with the 2 tables as ...
window 2003 server - You are the network administrator for a telecommunications ...
Access - A database has two tables named Products and Orders. The tables are ...
Computer Science-Java - Hi, I have to write a method that returns my first name...
Oracle - Im supposed to add the column Status to the Orderlines table. Its data ...
SQL server help! - A SQL statement is needed to create a stored procedure, which...
college/microeconomics - Just needing to know if I have done the work correctly ...
Oracle - I am supposed to do the following problem: Alter the s_ord table to add...
Microeconomics: - Just needing to know if I have done the work correctly with ...
SQL for business help - I have no idea where to begin with this. A SQL statement...

Search
Members