Generate a unique identity number on insert of a record

[venuchalla]

Hello,
I have created a table with fields like this
--------------------------------------------------------
CREATE TABLE [dbo].[Issues](
[CreatedByAlias] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Title] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ExpireAt] [datetime] NOT NULL,
[CreatedAt] [datetime] NOT NULL,
[Status] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CompleteTime] [int] NOT NULL,
[MailSent] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Issues_MailSent] DEFAULT (N'No'),
[NotifyAlias] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IssueNumber] [int] NOT NULL,
CONSTRAINT [PK_Issues] PRIMARY KEY CLUSTERED
(
[IssueNumber] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

-------------------------------------------------
When I am inserting a record from the form, I need a unique number generated automatically for that record in the table.

How can I do this, Can you please help me with the code.

 

[bborissov]

CREATE TABLE Issues(
......
[IssueNumber] [int] IDENTITY(1,1)
....

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.