-- bisp_Customers_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_Customers_SelectByPrimaryKey

      @CustomerID NChar(5)

AS

SELECT

      [Customers].[Address] AS [Address],

      [Customers].[City] AS [City],

      [Customers].[CompanyName] AS [CompanyName],

      [Customers].[ContactName] AS [ContactName],

      [Customers].[ContactTitle] AS [ContactTitle],

      [Customers].[Country] AS [Country],

      [Customers].[CustomerID] AS [CustomerID],

      [Customers].[Fax] AS [Fax],

      [Customers].[Phone] AS [Phone],

      [Customers].[PostalCode] AS [PostalCode],

      [Customers].[Region] AS [Region]

FROM [Customers]

WHERE

      [Customers].[CustomerID] = @CustomerID