TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Anil Kumar
NA
1
981
How to reset identity column value on date change in sql ser
Jan 24 2016 10:29 AM
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
Reply
Answers (
2
)
How to find Manager name of Employee
how to make auto sql notification using windows service....