SQL Server 2005

[moncelh]

Please, how to create a table with SQL statement in SQL Server 2005 including an ID number for the first field as well as an incrementation?

Thank you.

[Clanguage]

[HTML]GO
CREATE TABLE [dbo].[MyTable](
[id] [uniqueidentifie r] NOT NULL,
[AgentID] [int] NOT NULL,
[BusinessName] [varchar](25) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT NULL,
[Address1] [varchar](30) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT NULL,
[Address2] [varchar](30) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL,
[City] [varchar](20) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT NULL,
[State] [char](2) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT NULL,
[Zip] [varchar](10) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT NULL,
[County] [varchar](15) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT NULL,
CONSTRAINT [PK_ID] PRIMARY KEY NONCLUSTERED
(
[AgentID] ASC
) ON [PRIMARY]
) ON [PRIMARY][/HTML]
This SQL statement should give you an idea of what to do. The uniqueIdentifie r will automatically increase by one for each record. Just change the table name and the columns names and their datatypes and run the query. If you need to modify the table after it is created just change the CREATE to ALTER.
Good luck