jphilli
asked on
User-Defined Tables
I need to create a user defined table to insert data for two additional faculty members into my adjuncts table.
My table is set up like this:
(Faculty_ID Char(1),
LastName VARCHAR(20),
FirstName VARCHAR(20),
Department VARCHAR(10),
Campus VARCHAR(10),
Term CHAR(1));
My table is set up like this:
(Faculty_ID Char(1),
LastName VARCHAR(20),
FirstName VARCHAR(20),
Department VARCHAR(10),
Campus VARCHAR(10),
Term CHAR(1));
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much!
IF OBJECT_ID('YourTableName')
DROP TABLE YourTableName
GO
CREATE TABLE YourTableName
(Faculty_ID Char(1),
LastName VARCHAR(20),
FirstName VARCHAR(20),
Department VARCHAR(10),
Campus VARCHAR(10),
Term CHAR(1))
>to insert data for two additional faculty members into my adjuncts table.
So .. you have faculty and adjuncts tables? More details please.