我只想要have a value in both Disability 1 and Disability 2客户端(行)的结果。不想显示客户端(行)谁have a value in Disability 1 and NULL in Disability 2 or a NULL in Disability 1 and valuein Disability 2。我的专栏是ClientName, ClientNumber, ClientAge, ClientGender, Disabi
ALTER TABLE CLIENTS
add CONSTRAINT CHK_DISABILITY_INCOME_TYPE_ID CHECK ((IS_DISABLED IS NULL AND DISABILITY_INCOME_TYPE_ID看起来好像这个检查约束(IS_DISABLED IS NULL AND DISABILITY_INCOME_TYPE_ID IS NULL)的第一部分并没有被强制执行(见下文)。DISABILITY_INCOME_TYPE_ID的可用值为1和2,通过外键强制执行。IS_DISABLE