Question: how do I write sample INSERT STATEMENTS into this table created CREATE TABLE Supplier _ Payment ( Supplier _ Payment _ ID INT PRIMARY KEY,

how do I write sample INSERT STATEMENTS into this table created
CREATE TABLE Supplier_Payment (
Supplier_Payment_ID INT PRIMARY KEY,
Supplier_ID INT,
Amount DECIMAL(10,2),
Payment_Date DATE,
Remaining_Balance DECIMAL(10,2),
FOREIGN KEY (Supplier_ID) REFERENCES Supplier(Supplier_ID)
); monnominan
Object Explorer
Connect
External Tables
Graph Tables
dbo.AIRCRAFT
dbo.Bid
dbo.CHARTER
dbo.CREW
dbo.Customer
dbo.Customer_Payment
dbo.EARNEDRATING
dbo.EMPLOYEE
dbo.Material
dbo.MODEL
?TT
III
dbo.PILOT
dbo.RATING
dbo.Repair
dbo.retail_customers
dbo.retail_order_items
dbo.retail_orders
dbo.student
dbo.Supplier
dbo.Supplier_Payment
Columns
:'0 Supplier_Payment_ID (PK, int, no
~~ Supplier_ID (FK, int, null)
Amount (decimal(10,2), null)
Payment_Date (date, null)
Remaining_Balance (decimal(10,:
Keys
select * from supplier_payment
100%
Results
Supplier_Payment_ID
Supplier_ID
Amount
Payment
Date
Remaining_Balance
This is my table created I dont know how to populte fields
 how do I write sample INSERT STATEMENTS into this table created

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!