SCRIPT: Create A Table SQL Server 7.0

[SuperGrover]

Hello.

I am extremely new to SQL Server 7.0.
I am trying to write an SQL script to create
a new table within a Database.

I have absolutely no idea how to define a numeric field as both a primary field and an auto-number field (I mean that the records are automatically numbered). If somebody could help me, I would appreciate it very much.

I have also had incredible trouble trying to find any documentation about Table creation on the net.
Does anyone know of a very basic tutorial or site online. As I really need to know how to define different types of data such as datetime, integers etc.

 

[tlbroadbent]

Do you have the SQL electronic books called Books Online? They should be available on the SQL installation CD. If not you can download the setup file from Microsoft.

http://www.microsoft.com/sql/techinfo/productdoc/70/default.asp

The simple syntax for creating a table is...

CREATE TABLE jobs
(job_id int IDENTITY(1,1) PRIMARY KEY CLUSTERED,
job_desc varchar(50) NOT NULL,
min_lvl tinyint NOT NULL,
max_lvl tinyint NOT NULL)

job_id is the primary key and it will automatically increment from 1 by 1. Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost

 

[SuperGrover]

Thank you Terry.

I downloaded the files and your example, they have been very helpful.

Ross