SQL Server

posted by .

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.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. window 2003 server

    You are the network administrator for a telecommunications company in Rochester, New York. The network consists of two Windows Server 2003 systems and 57 Windows XP Professional systems. Both servers are used as domain controllers. …
  2. IT

    In this assignment, you are going to be gathering information about the future students of NSU at one of our open houses. Since there will be plenty of student candidates with interests on different programs, I would like you to create …
  3. Computer Science-Java

    Hi, I have to write a method that returns my first name, middle initial, and last name as a single String and call the method in java. So far, I have: public class ReturnName { static String fullname(String firstname, String middleinitial, …
  4. sql

    By using this table below I need to Write a SQL statement that creates a stored procedure with one int input parameter. The stored procedure selects the supplierId field and the total of all Count field values for each group of supplierId's …
  5. SQL for Business

    By using this table: CREATE TABLE Part ( Partid int IDENTITY PRIMARY KEY, Supplierid int NOT NULL REFERENCES Part (PartID), Description VARCHAR (25) NOT NULL, Count int NOT NULL, Class VARCHAR (5) NOT NULL, Inspection smalldatetime …
  6. Access

    A database has two tables named Products and Orders. The tables are joined by a column called ProductID. You have created a query named uery1, which combines the data from the tables. If the Products table is deleted, what will happen …
  7. SQL

    1- A SQL statement is needed to create a stored procedure that has one input parameter of data type int. The stored proc selects the supplierId field and the total, or sum, of all Count field values for each group of supplierId fields …
  8. SQL server help!

    A SQL statement is needed to create a stored procedure, which adds a new record to the Part table of week 3. The stored proc returns an out parameter that contains the value of the PartID PK of the record just added. Input parameters …
  9. programming

    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 Total Sales of each …
  10. buissness

    Data Security Password protect the database you created for your individual assignment in Week Three. Create a matrix to indicate the permissions (read, insert, delete, modify) you would grant to different users of your database. Create …

More Similar Questions