-- bisp_Orders_SelectByPrimaryKey generated on 11/28/2005 by Blue Ink

-- Do not modify this code as Blue Ink will delete and recreate this procedure on next generation

ALTER PROCEDURE dbo.bisp_Orders_SelectByPrimaryKey

      @OrderID Int

AS

SELECT

      [Orders].[CustomerID] AS [CustomerID],

      [Orders].[EmployeeID] AS [EmployeeID],

      [Orders].[Freight] AS [Freight],

      [Orders].[OrderDate] AS [OrderDate],

      [Orders].[OrderID] AS [OrderID],

      [Orders].[RequiredDate] AS [RequiredDate],

      [Orders].[ShipAddress] AS [ShipAddress],

      [Orders].[ShipCity] AS [ShipCity],

      [Orders].[ShipCountry] AS [ShipCountry],

      [Orders].[ShipName] AS [ShipName],

      [Orders].[ShippedDate] AS [ShippedDate],

      [Orders].[ShipPostalCode] AS [ShipPostalCode],

      [Orders].[ShipRegion] AS [ShipRegion],

      [Orders].[ShipVia] AS [ShipVia]

FROM [Orders]

WHERE

      [Orders].[OrderID] = @OrderID