Temple University

Get into SQL Management Studio and connect to your database. For this lab, you will need a table named . my_employee. To create this table, run this script in a Query window: CREATE TABLE my_employee (employee_id INT PRIMARY KEY NOT NULL, employee_name CHAR(20) NOT NULL, salary MONEY DEFAULT 25000); ................
................