Problem
TSQL - insert, update, delete
A. Construct an INSERT statement that includes a WHERE clause, Construct an UPDATE statement that includes a WHERE clause, and Construct a DELETE statement that includes a WHERE clause.
B. Why use the DML for insert, update, and delete rather than make changes directly with SSMS
C. How many rows can you insert with a single INSERT statement
D. UPDATEs and DELETEs can be destructive in nature. What statement might you use to see the rows that will be impacted before executing a DELETE or UPDATE?
E. If there were one area or topic from this unit (or past units) that could be focused on during class, what would you choose?
F. What topics in the Unit do you understand the best?