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

