Link to home
Start Free TrialLog in
Avatar of Jamie Poole
Jamie Poole

asked on

Error message of invaild data type in SQL Server Management Studio Express

I am getting an error message iwhen I try to execute this statement. I am taking a course and this is the sample database to work with throughout the chapter, so this is copied straight from the book. Please tell me I have copied something down wrong.


/*------------------------
CREATE TABLE DEPARTMENT(
	DepartmentName	VARCHAR			NOT NULL, 
	BudgetCode		Char(30)		NOT NULL, 
	OfficeNumber	Char(15)		NOT NULL, 
	Phone			Char(12)		NOT NULL,
	CONSTRAINT		DEPARTMENT_PK	PRIMARY KEY (DepartmentName
);
 
CREATE TABLE EMPLOYEE(
	EmployeeNumber	Int				NOT NULL IDENTITY (1,1)
	FirstName		Char(25)		NOT NULL,
	LastName		Char(25)		NOT NULL,
	Department		Char(35)		NOT NULL, DEFAULT 'Human Resources'
	Phone			Char(12)		Null, 
	Email			VarChar(100)	NOT NULL UNIQUE,
	CONSTRAINT		EMPLOYEE_PK		PRIMARY KEY (EmployeeNumber),
	CONSTRAINT		EMP_DEPART_FK	FOREIGN KEY (Department)
						REFERENCES DEPARTMENT(DepartmentName)
							ON UPDATE CASCADE
);
 
CREATE TABLE PROJECT(
	ProjectID		Int				NOT NULL IDENTITY(1000, 100),
	Name			Char(50)		NOT NULL, 
	Department		Char(35)		NOT NULL, 
	MaxHours		Numeric(8,2)	NOT NULL DEFAULT 100, 
	StartDate		DateTime		NULL,
	EndDate			DateTime		NULL, 
	CONSTRAINT		PROJECT_PK		PRIMARY KEY(ProjectID),
	CONSTRAINT		PROJ_DEPART_FK	FOREIGN KEY(Department)
						REFERENCES DEPARTMENT (DepartmentName)
							ON UPDATE CASCADE
);
 
CREATE TABLE ASSIGNMENT (
	ProjectID		Int				NOT NULL, 
	EmployeeNumber	Int				NOT NULL, 
	HoursWorked		Numeric(6,2)	Null, 
	CONSTRAINT		ASSIGNMENT_PK	PRIMARY KEY (ProjectID, EmployeeNumber), 
	CONSTRAINT		ASSIGN_PROJ_FK	FOREIGN KEY(ProjectID)
						REFERENCES PROJECT (ProjectID)
							ON UPDATE NO ACTION 
							ON DELETE CASCADE, 
	CONSTRAINT		ASSIGN_PROJ_FK	FOREIGN KEY(EmployeeNumber)
						REFERENCES EMPLOYEE (EmployeeID)
							ON UPDATE NO ACTION 
							ON DELETE NO ACTION
); 
------------------------*/
Major Error 0x80040E14, Minor Error 26302
> CREATE TABLE DEPARTMENT(
	DepartmentName	VARCHAR			NOT NULL, 
	BudgetCode		Char(30)		NOT NULL, 
	OfficeNumber	Char(15)		NOT NULL, 
	Phone			Char(12)		NOT NULL,
	CONSTRAINT		DEPARTMENT_PK	PRIMARY KEY (DepartmentName
)
The specified data type is not valid. [ Data type (if known) = VARCHAR ]

Open in new window

Avatar of CCongdon
CCongdon
Flag of United States of America image

On your code snippet, check the end of line 7. You're missing a closing parenthesis on the CONSTRAINT line.
Avatar of Jamie Poole
Jamie Poole

ASKER

CCongdon,
Thanks for noticing that, it still will not execute, Char does not turn blue, were Int and Numeric do.
ASKER CERTIFIED SOLUTION
Avatar of CCongdon
CCongdon
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you