-
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...
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|