Answer:
Kindly note that, you're to replace "at" with shift 2 as the brainly text editor can't take the symbol
If you are executing this script with any other script, Add "GO" to the line above "CREATE PROCEDURE", on a line all by itself, and it should fix that error of 'CREATE/ALTER PROCEDURE'
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
