Good evening everyone, I have been exploring this new tool (for myself) and ran into an issue that I cannot explain.
I have been using SQL 2008 and never had that problem.
The case is that within SQL 2019 I set the "Not null" property in certain fields of some tables. The problem is that either from my development environment (Visual Studio) or from a stored procedure or from the table's record editor, it allows me to save a record even though I passed an empty string to those "not null" fields.
I know that I could validate that data in the stored procedure, but I know that the function of the "not null" is precisely to control that aspect, so it is important to understand why it is allowing me to register null values in a not null field.
If anyone has any ideas or the same experience, I would greatly appreciate sharing your knowledge. Thank you in advance. Greetings.


