Wednesday
April 16, 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

window 2003 server - You are the network administrator for a telecommunications ...
SQL server help! - A SQL statement is needed to create a stored procedure, which...
SQL for business help - I have no idea where to begin with this. A SQL statement...
Database Management - What is wrong with using MS Access for a fifty station ...
windows 2003 server - You are the network administrator for an electrical goods ...
SQL for Business - By using this table: CREATE TABLE Part ( Partid int IDENTITY...
Computer Database SQL - Update the data in the Employees table so that employees...
Intro. to Comp. - I have 2 questions on an assignment that I need help with. 1....
programming - I have created a Database called Business with the 2 tables as ...
IT - Your network consists of four servers. Each server has three NICs. Server A...

Search
Members