ADF using Parameterized Stored Procedure
Introduction Here in this article, we are trying to demonstrate the Stored Procedure Activity of ADF and how we pass the parameters in it. Hope it will be interesting. Case Scenario We have a table named [ ProductInfo ]. It contains all the product name. CREATE TABLE ProductInto ( ProductID INT , ProductName VARCHAR ( 50 ) ) GO INSERT INTO ProductInto VALUES ( 1 , 'Tooth Past' ),( 2 , 'Tooth Brush' ) Now, we have another Table named [ OrderInfo ], contains all the order information. CREATE TABLE OrderInfo ( OrderID INT , ProductID INT , Qty INT , Rate DECIMAL ( 18 , 2 ) ) GO INSERT INTO OrderInfo VALUES ( 1 , 1 , 2 , 50 ), ( 1 , 2 , 1 , 30 ), ( 2 , 1 , 1 , 50 ) We are going to read one by one Product from our [ ProductInfo ] table, calculate the Order amount and insert records in [ ProductWiseOrderAmount ] Tabl