How to use two identity column in one table in sql server

Question

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...