Q: NOT NULL & CHECK on the same column ?
Posted in 1996
Hi all, My question is : if some CHECK constraint is defined on NOT NULL column, what is the order of validation of column value during INSERT/UPDATE ? Is CHECK condition applied before NOT NULL or vise versa ? Any help will be greatly appreciated. My opinions are those of my company. ///////// /// /// //////// ////// ///////// // /// ///// /// /// /// /// /// /// // /// // /// /// /// /// /// // /// //////// ////// /// // /// /////// /// /// /// // // /// /// /// /// /// /// /// ///////// //// //// //////// /// /// /// /// ////// //// Best Regards, QWERTYS Ltd. Sergei Vasilyev, 10, Elektrodnaya St., +7 (095) 368-8061 App # 425, E-Mail : serg@qws.msk.su Moscow, Russia, June 19, 1996, 18:05 111524.