-
having problems creating tables
--create employees tables
use J_adame_koddkerff1;
create table employees_table_jadame
(
empid int identity(100,1) primary key,
lname varchar(40) not null,
fname varchar(20) not null,
Address varchar(40) not null,
City varchar(15) not null,
State varchar(2) not null,
zipcode varchar(5) not null,
Telephone_Number varchar(12) not null,
hire_date date not null,
salary money not null,
Gender varchar(1) not null,
Number_of_Dependents int(2) not null,
);
I get this error--------
Msg 2716, Level 16, State 1, Line 3
Column, parameter, or variable #12: Cannot specify a column width on data type int.
-
On which rdbms? Tried replace int(2) with bigint or alike?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|