Serial Data Type

[marcela24]

Is there a serial data type in MS Sql Server?
How is it?

 

[SQLSister]

What do you mean by a serial data type? Explain the kind of data it contains and maybe we can help you.

 

[marcela24]

Sorry, its an increment. It's an id, an int type, automatically incremented.

Hope i made it clear.

 

[swampBoogie]

You can specify an identity attribute for a column. Look it up in BOL.

 

[SQLSister]

Look up identity in Books online. Here's a sample create table with an identity field as one of the columns.

CREATE TABLE [dbo].[CityLocation] (
[City] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[State] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Latitude] [decimal](10, 3) NULL ,
[Longitude] [decimal](10, 3) NULL ,
[CityLatLonID] [int] IDENTITY (1, 1) NOT NULL ,
[InfoType] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

 

[marcela24]

I got it!
create table A
(
id int identity (1, 1),
...
)

 

[SQLSister]

Yeah, but don't use the column name ID, be more specific like CustomerID or VendorID. You'll thank me for this later when you need to use the IDs from different tables and add foreign keys.