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
Kanaparthi Sureshma Reddy
NA
85
38.5k
Generating alphanumeric autogenerated ID
May 15 2015 6:49 AM
I want to generate alphanumeric student Id based on department for BTECH students using SQL Server like 10F21A0404.In this,the ID will be incremented up to 499 and after that it should be incremented as 4A0-4A9 and 4B0-4B9 and etc..For other departments also it has increment as 10F21A0500 like wise it has to increment 5A0-5A9 and etc
Reply
Answers (
1
)
Suddenly I am getting error when opening SQL SERVER MANAGMEN
How to solve current queries in SQL Server?