MySQL

Help with generating a unique number

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Aug 2009

Posts: 9

Reputation: kevlam is an unknown quantity at this point

Solved Threads: 0

kevlam

Offline

Newbie Poster

Help with generating a unique number

Oct 7th, 2009

hello,

I'm trying to create a database in SQL Server management Studio for a project. I have created a tabel named Employee and I have 14 columns. I need to set the firts column (Emp_ID) as Primary Key (accomplished) and then generate a unique number for each Emp_ID that I insert. currently I have no information in my database I'm stuck in finding the procedure to correctly code the SQL statement that will generate a unique Emp_ID when I insert new values or add a new row of information. Can someone please help? I"ve look all over my text and searched the web and cannot find something useful to help.

thanks in advance

•

Join Date: Jan 2009

Posts: 1,392

Reputation: almostbob has a spectacular aura about

Solved Threads: 168

almostbob

Offline

Nearly a Posting Virtuoso

Oct 8th, 2009

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
CREATE TABLE Employee
(
Emp_Id INT PRIMARY KEY IDENTITY,
LastName VARCHAR(255) NOT NULL,
FirstName VARCHAR(255),
Address VARCHAR(255),
City VARCHAR(255),
postalcode vachar(6),
/* other columns*/
)
CREATE TABLE Employee
(
Emp_Id int PRIMARY KEY IDENTITY,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
postalcode vachar(6),
/* other columns*/
)

not sure about sql server, identity SHOULD be the keyword to make it autoincrement

Last edited by almostbob; Oct 8th, 2009 at 12:35 am.

Failure is not an option It's included free, you don't have to do anything to get it
If at first you dont succeed, join the club
Of course its always in the last place you look, you dont keep looking after you find it

Please mark solved problems, solved