---------------------------------------------------------------------
-- SQL Server 2005XgAhvV[WvO~O
-- t^B XgAhvV[W̃RpC^ۑ^ėp
---------------------------------------------------------------------

---------------------------------------------------------------------
-- B.2 sv̍ėp
---------------------------------------------------------------------

SELECT *
FROM Asset5.dbo.Inventory


SELECT FirstName, LastName, Phone, Fax, Email, OrgUnitId, UserName
FROM Asset5.dbo.Contact
WHERE ContactId = 3


SELECT FirstName, LastName, Phone, Fax, Email, OrgUnitId, UserName
FROM Asset5.dbo.Contact
WHERE ContactId = @P1


SELECT FirstName, LastName, Phone, Fax, Email, OrgUnitId, UserName
FROM Asset5.dbo.Contact
WHERE ContactId = 11

---------------------------------------------------------------------
-- B.3 XgAhvV[W̍ăRpC
---------------------------------------------------------------------

EXEC sp_recompile dbo.ap_OrdersByCountry_List


EXEC sp_recompile Orders


CREATE PROCEDURE dbo.ap_OrdersByCountry_List
    @Country CHAR(3)
WITH RECOMPILE
AS
    SELECT * FROM dbo.Orders
    WHERE Country = @Country


EXEC dbo.ap_OrdersByCountry_List 'USA' WITH RECOMPILE

