FIGURE Ch08 SimpleCo database tables P8.1 Database name: Ch08_SimpleCo Table name: CUSTOMER Table name: INVOICE CUST NUM CUST LNAME CUST ENAME CUST BALANCE 1000 Smith 1001 Ortega INV_NUM CUST_NUM INV DATE | INV_AMOUNT Jeanne 1050.11 8000 1000 23-Mar-14 235.89 Juan 840.90 8001 1001 23-Mar-14 312.82 8002 1001 30-Mar-14 528.10 Table name: CUSTOMER 2 8003 1000 12-Apr-14 194.78 CUST NUM CUST UNAME CUST FNAME 8004 1000 23-Apr-14 619.44 2000 McPherson Anne 2001 Ortega Juan 2002 Kowalski Jan 2003 Chen George Cengage Learning © 2015
FIGURE Ch08 SimpleCo database tables P8.1 Database name: Ch08_SimpleCo Table name: CUSTOMER Table name: INVOICE CUST NUM CUST LNAME CUST ENAME CUST BALANCE 1000 Smith 1001 Ortega INV_NUM CUST_NUM INV DATE | INV_AMOUNT Jeanne 1050.11 8000 1000 23-Mar-14 235.89 Juan 840.90 8001 1001 23-Mar-14 312.82 8002 1001 30-Mar-14 528.10 Table name: CUSTOMER 2 8003 1000 12-Apr-14 194.78 CUST NUM CUST UNAME CUST FNAME 8004 1000 23-Apr-14 619.44 2000 McPherson Anne 2001 Ortega Juan 2002 Kowalski Jan 2003 Chen George Cengage Learning © 2015
Programming with Microsoft Visual Basic 2017
8th Edition
ISBN:9781337102124
Author:Diane Zak
Publisher:Diane Zak
Chapter11: Sql Server Databases
Section: Chapter Questions
Problem 3RQ
Related questions
Question
Write a procedure to add a new invoice record to the INVOICE table. Use the following values in the new record:
8006, 1000, '30-APR-14', 301.72
Name the procedure prc_invoice_add. Run a query to see if the record has been added. S
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 3 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning