Insert statement with where clause.
Posted
by debraj
on Stack Overflow
See other posts from Stack Overflow
or by debraj
Published on 2010-03-29T02:31:36Z
Indexed on
2010/03/29
2:33 UTC
Read the original article
Hit count: 321
I had a table with unique Date_t1 date type field, but in Table description field is not mentioned as unique, now while inserting new row i need to validate if date exist or not, If already exist i should not allow to make changes on that row, neither a new row needs to be created, Any idea how to resolve this problem in efficient way,
© Stack Overflow or respective owner