SqlInsert Query I am unable to restirct Duplicate entries

sankeerth m

"INSERT INTO kpicolor(KPIName, MinVal, MaxVal, ColorVal, Markersize, UserSession) " +

"SELECT * FROM(SELECT @KPIName, @MinVal, @MaxVal, @ColorVal, @Markersize, @UserSession) AS tmp WHERE NOT EXISTS " +

"(Select KPIName from kpicolor where @MinVal between MinVal And MaxVal And KPIName = @KPIName AND UserSession='" + userSession + "'); ";

if i am adding 1 to 50 it is restricting between numbers. if i add 51 to 100 it is appending the row. after that i am inserting 101 to above numbers it unable to insert. but if add from 52 to 150 it adding again. please help me out this sql query

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg6y ago
Select * from kpicolor where KPIName='12133'; if it returns any value then don't insert otherwise insert. Also follow this link which contains example, https://stackoverflow.com/questions/27115045/check-for-duplicate-entries-before-insertion-c-net
0
Salman Beg6y ago
Before inserting, first check the name whether it exists or not in the database. If it exists then don't insert and show validation otherwise insert. This way you can perfectly handle duplicate records insert. Thanks
0