USE [NWind]
GO
/****** Object: StoredProcedure [dbo].[USP_CustomerDetails] Script Date: 11/6/2023 11:41:01 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[USP_CustomerDetails]
(
	@City NVARCHAR(100)
)
AS
BEGIN
	SET NOCOUNT ON;
	SELECT
		[CustomerID],
		[CompanyName],
		[ContactTitle],
		[Address],
		[City],
		[Region],
		[PostalCode],
		[Country],
		[Phone],
		[Fax]
	FROM [Customers]
	WHERE [City] like @City
	ORDER BY [CustomerID];
	SET NOCOUNT OFF;
END
