CST 1204 Chapter Notes - Chapter 8: Procedural Programming, Item Number, Stored Procedure

69 views5 pages

Document Summary

Use upper and lower functions with character data. Use round and floor functions with numeric data. Add a specific number of months or days to a date. Learn to embed sql in pl/sql or t-sql. Useful when needed tasks are beyond the capabilities of sql. List the rep number, the first name of the rep in lower case, and the last name of the rep in upper case. List the item number and price for all items. Round the price to the nearest whole dollar amount. Floor function - rounding down/ cuts off anything after the decimal. Adds a specific number of months to a date. Access and sql server use dateadd function to add months. For each order, list the order number and the date that is two months after the order date. For each order, list the order number and the date that is 7 days after the order date.

Get access

Grade+
$40 USD/m
Billed monthly
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
10 Verified Answers
Class+
$30 USD/m
Billed monthly
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
7 Verified Answers

Related Documents

Related Questions