I'm trying to insert into a simple table, but a field of it, is not saving the value I'm passing to it, and the strangest thing is that all other columns get right. Example
INSERT TabelaExemplo (id, nome, outroId) values (1,'Gabriela', 2)
It is inserted successfully, but the column outroID appears null when I give the select in that table. It is important to note that the column otherId is INT and accepts null values. But when passing values should the data persist right?
Other column data given by sp_help
Column_name outroId
Type int
Computed no
Length 4
Prec 10
Scale 0
Nullable yes
TrimTrailingBlanks (n/a)
FixedLenNullInSource (n/a)
Collation NULL
Does anyone have any idea why this is happening?