1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
| USE [AdventureWorksLT2019]
GO
/****** Object: StoredProcedure [SalesLT].[spOrder] Script Date: 03/01/2023 19:05:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
CREATE PROCEDURE [SalesLT].[spOrder]
-- Add the parameters for the stored procedure here
@pFirstName NVARCHAR(MAX) = NULL
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
--SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2>
IF OBJECT_ID('tempdb.dbo.##tCustomerTop', 'U') IS NOT NULL
DROP TABLE ##tCustomerTop
SELECT TOP (100) *
INTO ##tCustomerTop
FROM SalesLT.Customer
WHERE ( @pFirstName is null or FirstName = @pFirstName)
CREATE CLUSTERED INDEX idx_t ON ##tCustomerTop ([CustomerID])
SELECT * FROM ##tCustomerTop
DROP TABLE ##tCustomerTop
/*SELECT SalesLT.Customer.CustomerID
, SalesLT.Customer.FirstName
, SalesLT.Customer.MiddleName
, SalesLT.Customer.LastName
, SalesLT.CustomerAddress.*
, SalesLT.SalesOrderHeader.*
, SalesLT.SalesOrderDetail.*
, SalesLT.Product.*
FROM SalesLT.Customer
INNER JOIN SalesLT.CustomerAddress ON SalesLT.Customer.CustomerID = SalesLT.CustomerAddress.CustomerID
INNER JOIN SalesLT.SalesOrderHeader ON SalesLT.Customer.CustomerID = SalesLT.SalesOrderHeader.CustomerID
INNER JOIN SalesLT.SalesOrderDetail ON SalesLT.SalesOrderDetail.SalesOrderID = SalesLT.SalesOrderHeader.SalesOrderID
INNER JOIN SalesLT.Product ON SalesLT.Product.ProductID = SalesLT.SalesOrderDetail.ProductID*/
END |
Partager