I have added check constraint on table. I am calling one function in that check constraint.
Actually I have to prevent two records of same type should not have same date range as a result of
Added check constraint like...
ALTER TABLE TABLENAME WITH NOCHECK ADD CONSTRAINT [CHK_TABLENAME] CHECK ((dbo.PAEXTENDADD_DUPLICATECHK (ID, VALIDFROM, VALIDTO) = 1))
Just want to know how does it works?? I mean is it work like first update will be done then go for check constraint validation. if check constraint violated then it will rollback.
is it so??
Why do you create with "WITH NOCHECK"?
Try with "WITH CHECK" or try with "WITH CHECK CHECK".
Enabling with double CHECKs means enabling the constraint and checking whether the data in the table satisfies the constraint defined with the check constraint, i.e you're making the constraint trusted. After entrusting, you'll also see differences in the execution plans of queries using the trusted constraints.
SQL Server developer at Seavus