Здравейте колеги,

Всичко е наред преди да се пробвам да вкарам данни в таблицата. Някакви идеи?

CREATE TABLE People
(
Id INT IDENTITY,
Name NVARCHAR(200) NOT NULL,
Picture VARBINARY(MAX),
Height DECIMAL(10,2),
Weight DECIMAL(10,2),
Gender VARCHAR(1) NOT NULL,
Birthdate DATE NOT NULL,
Biography NVARCHAR(MAX),
)
ALTER TABLE People
ALTER COLUMN Id INT NOT NULL

ALTER TABLE People
ADD PRIMARY KEY (Id)

ALTER TABLE People
ADD CONSTRAINT CH_PictureSize CHECK(DATALENGTH(Picture)<2000*1024)

ALTER TABLE People
ADD CONSTRAINT CH_Biography CHECK(DATALENGTH(Biography)<1000000*1024)

ALTER TABLE People
ADD CONSTRAINT CH_Gender CHECK(Gender='m' or Gender='f')

INSERT INTO People (Name,Height,Weight,Gender,Birthdate,Biography)
VALUES 
('Pesho',1.73,89,'m','1987-02-03','alabala'),
('gosho',1.7,59,'m','1999-05-04','faaaaaa'),
('maya',1.55,49,'f','1995-05-05','kaktaka'),
('zornitsa',1.69,59,'f','1993-06-07','qpa ti'),
('imeto',1.89,90,'1980-08-08','m',NULL)

ГРЕШКАТА:

Msg 8152, Level 16, State 14, Line 27
String or binary data would be truncated.
The statement has been terminated.