Create Database, Create Table, Alter Table, Insert, Update, and Delete When Constraints May Be Violated
Unit 9
Alexander Diaz
Kaplan University
August 12, 2014

Unit 9
-- Q1. Use tempDB -- Create a table called MyNewTable with three columns (rowID smallint, createdDate datetime, name varchar with a length of 30)
[pic]

-- Q2. Use tempDB -- Create a script that checks to see if MyNewTable Exists, drop it if it does.
Recreate the query in Question 1 so that table does not allow an insert where the createdDate is less than the current datetime --- Insert a row into MyNewTable using the current datetime value--- If your Insert completed successfully something is wrong with your previous statements. If it failed? Explain why and how you might change the create table --- In order to fix the problem, assuming you always want to insert every row using the current date time value. Hint -- Search for -- "adding a second to a date field SQL"
[pic]
I believe using the smalldatetime option in order to use the ‘ss’ for the two digits to represent the ranging value from 00 to 59. Also using an alias for the table name in order for the query to proceed without errors.

-- Q3. In the script above, Explain exactly why you cannot update col1 for the final two statements in the list.
Each column in a table must have a specific data type and usually a maximum size that controls what data can be inserted or updated and whether a column may contain NULL values. You can’t add a non-numeric string to an INT column. It is also possible to further control what data you can add by defining check constraints. For example, you may want to restrict the values of a column to a particular range of values.
-- Q4. Using Alter Table statements. Add a new Column to MyNewTable (see q1 above) column name =primaryID (as an INT)
-- Add a Primary Key Constraint to