Activity overview
Latest activity by Sabine
Thank you - but to clarify: we need something like a constrait. One of two nullable columns should be NULL, but NOT both and also NOT none. or with other words. if one column is NOT NULL the other column MUST be NULL. BUT: we need both situations we like to have sometimes column 1 to be NULL and sometime the column 2 should be NULL which column (1 or 2) MUST have an value depends on column attribute_key in the sample if IDAttributeKey = 1 THEN AttributeValueInt MUST be NULL (and AttributeValueDate MUST NOT be NULL) if IDAttributeKey = 2 THEN AttributeValueDate MUST be NULL (and AttributeValueInt MUST NOT be NULL) / comments
Thank you - but to clarify: we need something like a constrait.One of two nullable columns should be NULL, but NOT both and also NOT none.or with other words. if one column is NOT NULL the other co...
Data generation depending on other column
Hello, we have a customer table and have to store various
attributes for the customer data in an extra attribute table (simplified
structure):
CREATE TABLE
[Customer].[tAccounts](
...