How to use two identity or auto increment column in one table in sql server??
i am creating a table for Hospital patientOpd
CREATE TABLE [dbo].[PatientOpd](
[Id] [int] NOT NULL,
[OpdNo] [int] IDENTITY(1,1) NOT NULL,
[CreatedOn] [datetime] NOT NULL,
[Name] [nvarchar](50) NULL,
)
i want to that id and OpdNo should be auto increment value
as Opd no will be reset daily and
Id will be increment continuously...
1 Reply
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Mithun PattankarPosted Jan 29, 2016, 3:00 AM