Listing 1: Script to Create a Database, Table, and Stored Procedure
DROP DATABASE testdb
GO
CREATE DATABASE testdb
GO
USE testdb
GO
SELECT * INTO Orders
FROM Northwind..orders
GO
CREATE INDEX CustID_index ON Orders(CustomerID)
GO
CREATE PROC getorders
(@custID nchar(5) )
AS
SELECT * FROM Orders
WHERE CustomerID = @custID
GO