Can anyone help me with an 'IF' statement that will prevent saving a duplicate record in MSSQL
RRUDMAN
0
Newbie Poster
Recommended Answers
Jump to Postthis depends on how you have designed your database. you should have an ID field which is the number of record and this to be an PK.
in this way all fields are identified with an unique ID.second step:
create an trigger to verify if the element exist …
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.