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

68 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+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents

Related Questions