oracle to microsoft sql syntax conversion

[neroe]

thanks in advance for any help on this. im a newbie to sql so this question probably is so simple for you guys.

can anyone change the syntax of this line in order for sql server 2000 to take any notice of it

constraint emp_pk primary key (emp_id);

 

[JamesLean]

Are you trying to add this PK to an existing table? If so:

ALTER TABLE emp
ADD CONSTRAINT emp_pk PRIMARY KEY (emp_id)

If not, what ARE you trying to do? ;-)

--James

 

[neroe]

im creating this table;

create table employee_tbl
(
emp_id varchar(9) not null,
last_name varchar(15) not null,
first_name varchar(15) not null,
middle_name varchar(15),
address varchar(30) not null,
city varchar(15) not null,
state char(2) not null,
zip number(5) not null,
phone char(10),
pager char(10),
constraint emp_pk primary key (emp_id);

its taken from a book that uses an oracle sql syntax. im altering it to sql server 2000 syntax. originally the varchar was varchar2 so i changed that. i got stuck on the primary key bit. does that make sence?

 

[swampBoogie]

The syntax for the primary key part is ok but you are missing the closing ).

Also, number(5) is not a standard type. Change that to decimal(5)

 

[neroe]

thanks very much, that works perfectly.

 

[SQLSister]

It might be best to get a book with T-SQL syntax as Oracle syntax is very different. Also you can look up the syntax for things yourself in Books Online.