Hello all
In a table (with 2 cols) i want to insert 2 values say
"33" and
"hrishi"( 1 record )
only if the same values does not exist ie.."33" and
"hrishi" (1 record ).
can this be done through a single sql statement.
regards
Hrishy
Printable View
Hello all
In a table (with 2 cols) i want to insert 2 values say
"33" and
"hrishi"( 1 record )
only if the same values does not exist ie.."33" and
"hrishi" (1 record ).
can this be done through a single sql statement.
regards
Hrishy
you mean PK/UNIQUE behaviour without setting constraint?
Hello Pando
Nope i would first like to check whaether the record which i want to insert exists if no then i would like to insert this record using a single insert statement is this possible.
regards
Hrishy
You could use a composite primary/unique key for the 2 columns in question.
You could use an instead-of insert trigger to check your data before you insert into the table...