Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
How to reset identity column value on date change in sql ser
Anil Kumar
Jan 24 2016 10:29 AM
342
Reply
i am creating query for hospital patient opd
i want that opd no shuld be reset and start with 1 on date change like
Date opdNo
20-01-2016 01
20-01-2016 02
20-01-2016 03
20-01-2016 04
20-01-2016 05
21-01-2016 01
21-01-2016 02
21-01-2016 03
22-01-2016 01
22-01-2016 02
Is it possiable in sql ??
please help
Thanks
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
How to find Manager name of Employee
how to make auto sql notification using windows service....