MSDN Documentation

SQL Server Intermediate Tutorials

Dive deeper into SQL Server with these intermediate-level tutorials, covering essential concepts and practical techniques for efficient database management and development.

Example: Creating a View

Let's look at a simple example of creating a view to show customer names and their total order values. Assume we have a Customers table and an Orders table.

SQL Code:

CREATE VIEW CustomerOrderSummary AS
SELECT
    c.CustomerID,
    c.FirstName + ' ' + c.LastName AS CustomerName,
    SUM(o.TotalAmount) AS TotalOrderValue
FROM
    Customers c
JOIN
    Orders o ON c.CustomerID = o.CustomerID
GROUP BY
    c.CustomerID, c.FirstName, c.LastName;
                    

Querying the View:

SELECT *
FROM CustomerOrderSummary
ORDER BY TotalOrderValue DESC;
                    

This view simplifies retrieving aggregated order information for each customer. You can treat it like a table in your queries.