I have recently installed SQL 2008 R2
CREATE TABLE TPERSONS(
personid int PRIMARY KEY NOT NULL,
lastname varchar(50) NULL,
firstname varchar(50) NULL,
salary money NULL,
managerid int NULL -- foreign key to personid
)
I do not understand why I receive this error.
Major Error 0x80040E14, Minor Error 26302
)
The specified data type is not valid. [ Data type (if known) = varchar ]
The data type varchar is not one of the supported data types on SQL Server CE. You must use nvarchar.
Note that date is not supported, either. Use datetime instead.
User contributions licensed under CC BY-SA 3.0