Hi, I just created a table with
create table X (
I then check the table properties with sp_help X and what I saw is the var1 column only has length of 1 and var2 has length of 2.
I know tinyint is 1 byte so it goes up to 255 and small int is 2 bytes so it goes up to 2^8 number I think. Will SQL server increase my field length automatically?