RE: [SPAM] - Need Help with Create Table in SQL Server - Found word(s) list error in the Text body
- From: Rodney Haynie <RodneyH@xxxxxxxxxx>
- To: "programmingblind@xxxxxxxxxxxxx" <programmingblind@xxxxxxxxxxxxx>
- Date: Fri, 26 Oct 2007 23:37:27 -0400
Ray,
The Primary Key clause should be within the parentheses of the Create Table,
separated by a comma.
I modified the statement below.
CREATE TABLE customer
(customer_number int not null, customer_name varchar(25) not null,
customer_address varchar(25) not null, customer_city varchar(20) not null,
customer_state char(2) not null, customer_zip varchar(10) not
Null,
PRIMARY KEY (customer_number));
-----Original Message-----
From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Ray Campbell
Sent: Friday, October 26, 2007 12:23 PM
To: programmingblind@xxxxxxxxxxxxx
Subject: [SPAM] - Need Help with Create Table in SQL Server - Found word(s)
list error in the Text body
Hello All:
I'm running into a problem creating a table in SQL server, ans ad far as
I can tell from what I've read I'm doing everything correctly. My
command is:
CREATE TABLE customer
(customer_number int not null, customer_name varchar(25) not null,
customer_address varchar(25) not null, customer_city varchar(20) not
null, customer_state char(2) not null, customer_zip varchar(10) not
null)
PRIMARY KEY (customer_number);
When I run this in the Query Analyzer of SQL Server 2000 on an existing
database, I get a syntax error and the table doesn't get created. I've
looked at various SQL references on google and this seems to be the
correct syntax. What am I doing wrong?
Thanks for any help.
Ray Campbell, Help Desk Technician
Adaptive Technology Center
Chicago Lighthouse for People Who Are Blind or Visually Impaired
1850 W. Roosevelt Road
Chicago, IL 60608
312-997-3651 (Voice/Relay) or
888-825-0080 (voice/Relay)
ray.campbell@xxxxxxxxxxxxxxxxxxxxx
AIM Screen Name: tclhelp
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
- » RE: [SPAM] - Need Help with Create Table in SQL Server - Found word(s) list error in the Text body
