INSERT INTO Sales.SalesTerritory ( [NAME], CountryRegionCode, [Group]) VALUES ( 'Pacific Islands', 'US', 'North America');
Why didn't the INSERT fail? To some extent, I understand. A subsequent query reveals that attribute values not provided in the INSERT are indeed NOT NULL. But how did that happen?
Take the SalesYTD attribute for example. The query shows a value of 0.00. Is the answer to my above question in the following screenshot?