Results 1 to 2 of 2

Thread: having problems creating tables

  1. #1
    Join Date
    Aug 2011
    Posts
    1

    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.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    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
  •