Kenny works with an IT company. His company is about to launch new software in the market. He has to ensure that this new softwa
1 answer:
You might be interested in
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.
