Two errors with the same error number

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Amin Sobati (amins_at_morva.net)
Date: 04/06/04 

Date: Tue, 6 Apr 2004 12:01:05 +0430

Hi,
I have two check constraints on my table. Suppose user inserts a record that
violates
both of these constraints, then SQL server returns an error to user(client
app).
If both of these violations have the same error number, how should I
identify that
violation of which constraint has occurred so that display the appropriate
message to user in my error handling code.
Any help would be greatly appreciated.
Amin

Relevant Pages

  • Re: Counter example for Mr. Diaby algorithm solving TSP problem in polynomial time
    ... violates some z's restrictions... ... I'll update six valleys example to 8 - it'll be bit more clear. ... generate Soplex LPT file with all equations. ... the "visit restrictions" constraints (constraints 2.14 in latest ...
    (comp.theory)
  • Re: C Standard Regarding Null Pointer Dereferencing
    ... I think this violates no constraints so 6.3.2.2 p1 is important to ... Initialising a scalar does not provide a simpler example because 6.7.8 ... The initializer for a scalar shall be a single expression, ...
    (comp.lang.c)
  • Re: Exiting: the constraints are overly stringent;
    ... but, when I tried to increase the value of d, I get an error message: the constraints are overly stringent; ...  initial feasible point found violates constraints ... If there is at least one row index i with d>0 for which the above ...
    (comp.soft-sys.matlab)
  • Re: Bubble Sort in C
    ... It violates a "shall" that does not occur in a constraints section; ... That would fit my expectations. ...
    (comp.lang.c)
  • Two errors with the same number
    ... I have two check constraints on my table. ... then SQL server returns an error to user(client ... message to user in my error handling code. ...
    (microsoft.public.sqlserver.server)