Use INSERT with parameters to append a new record in a table
INSERT INTO Customers ( CustomerID, CompanyName, ContactName, Phone )
VALUES (@CustomerID, @CompanyName, @ContactName, @Phone);
The stored procedure allows you to insert a new record with the valued fields (CustomerID, CompanyName, ContactName, Phone) in the Customers table.