Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
How to use two identity column in one table in sql server
Anil Kumar
Jan 29 2016 2:38 AM
381
Reply
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...
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Using Comand (%LIKE%) to check data in the column
What is Injection in Sql or Sql Injection