Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Participant
1395 Points
385 Posts
Feb 06, 2011 11:16 AM|LINK
Do like this...
Serial No Card ID
SH123 123
SH124 124
//suppose 125 deleted
SH126 126
make Card No as Primary key and Serial No as SH+Card No.
suppose Card No is 143 then Serial No is SH+143=SH143..
I hope u like this solution,
If so please mark as ANSWER.
Many Thanks,
Gouse BAig.
ReenuGouse
Participant
1395 Points
385 Posts
Re: Insert Large Amount Of Data in Sql Server 2005 Database With every time duplicate Check
Feb 06, 2011 11:16 AM|LINK
Do like this...
Serial No Card ID
SH123 123
SH124 124
//suppose 125 deleted
SH126 126
make Card No as Primary key and Serial No as SH+Card No.
suppose Card No is 143 then Serial No is SH+143=SH143..
I hope u like this solution,
If so please mark as ANSWER.
Many Thanks,
Gouse BAig.