Why does SQL server express 2008 give me this error?
CREATE TABLE model (
name varchar(3),
desc varchar(25)
)
0x80040E14, Minor Error 26302
> CREATE TABLE model (
name varchar(3),
desc varchar(25)
)
The specified data type is not valid. [ Data type (if known) = varchar ]
Because DESC is a SQL keyword. You can either use a different column name (say, description) or put brackets around desc:
[desc] VARCHAR(25)
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