SQL server want to change the sage in the table data type to tinyint, why not ask the great spirit show

CodePudding user response:

The ALTER TABLE TABLE name the ALTER COLUMN sage tinyint

CodePudding user response:

This I also tried, but no success

CodePudding user response:

refer to the second floor weixin_45691453 response:

this I also tried, but didn't change success

Prompt what mistake? Tinyint length is not enough, or the existing data have not the int type

CodePudding user response:

The data contains Spaces, from string is less than a numeric type,,,

CodePudding user response:

Thank you bosses, just the problem is solved, and now there is a problem is a TXT import less than local database, I define the grade tinyint should be no problem, but is not in