• mote.ajit2 (9/27/2013)


    Just want to know how does it works?? I mean is it work like first update will e done then go for check constraint validation. if check constraint violated then it will rollback.

    i dont think first it will update/insert the value in column and if validation fails , it rolls back. Sql server engine should not be design to work like this.

    i also googled for same things but couldnt find anything.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)