Answer:
Check the explanation
Explanation:
CREATE PROCEDURE sp_Q1
<u><em>"at"</em></u>country1 NVARCHAR(15),
<u><em>"at"</em></u>country2 NVARCHAR(15)
AS
BEGIN
BEGIN
SELECT SupplierID, CompanyName, Phone, Country FROM suppliers
where Country in (<u><em>"at"</em></u>country1,<u><em>"at"</em></u>country2)
SELECT ProductID, ProductName, UnitPrice, SupplierID FROM Products
where SupplierID in(
SELECT SupplierID FROM suppliers
where Country in (<u><em>"at"</em></u>country1,<u><em>"at"</em></u>country2)) ORDER BY SupplierID
END
END
GO
-- Testing script.
DECLARE <u><em>"at"</em></u>RC int
DECLARE <u><em>"at"</em></u>country1 nvarchar(15)
DECLARE <u><em>"at"</em></u>country2 nvarchar(15)
-- Set parameter values here.
set <u><em>"at"</em></u>country1='UK'
set <u><em>"at"</em></u>country2='Canada'
EXECUTE <u><em>"at"</em></u>RC = [dbo].[sp_Q1]
<u><em>"at"</em></u>country1
,<u><em>"at"</em></u>country2
GO
Kindly check the attached images below to see how it looks like on a code editor.
