I'm new here. I'm attempting to create a table in ms sql database using mylittleadmin. I've read and reread the code and can't seem to figure out why I am getting the following error:
"Msg 2716, Level 16, State 1, Line number 1 Column, parameter, or variable #8: Cannot specify a column width on data type int."
The code is as follows...
CREATE TABLE surrogate(
Last_Name1 VarChar(255),
First_Name1 VarChar(255),
ID int,
Street_Address int,
City VarChar(255),
State_or_Province VarChar(255),
Country VarChar(255),
Zip_Code int(255),
Home_Phone int,
Mobile_Phone int,
Work_Phone int,
Email VarChar(255),
Last_Name2 VarChar(255),
First_Name2 VarChar(255),
ID int,
Street_Address2 int,
City2 VarChar(255),
State_or_Province2 VarChar(255),
Country2 VarChar(255),
Zip_Code2 int,
Home_Phone2 int,
Mobile_Phone2 int,
Work_Phone2 int,
Email2 VarChar(255),
Last_Name3 VarChar(255),
First_Name3 VarChar(255),
ID int,
Street_Address3 int,
City3 VarChar(255),
State_or_Province3 VarChar(255),
Country3 VarChar (255),
Zip_Code3 int,
Home_Phone3 int,
Mobile_Phone3 int,
Work_Phone3 int,
Email3 VarChar(255))
Its just a typo mistake. Guess you haven't seen it yet. This is the problem:
Zip_Code int(255),
Change it to
Zip_Code int,
Hope this helps!!!
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With