I have an Error message, plz help
-
Hi, plz, help me with the following, (the code is attached) Trying to insert, I have the following message: (1 row(s) affected) Server: Msg 8152, Level 16, State 9, Procedure Trig_PUD, Line 8 String or binary data would be truncated. The statement has been terminated. the Code is: CREATE TABLE PersonalFile ( IDnum int identity(1,1) not null, PersonalFile varchar(10) not null CONSTRAINT PK_PersonalFile PRIMARY KEY ) CREATE TABLE University ( PersonalFile varchar(10) not null CONSTRAINT PK_UniversityPF PRIMARY KEY REFERENCES PersonFile, University varchar(50) not null ) CREATE TABLE Department ( PersonalFile varchar(10) not null CONSTRAINT PK_DepartmentPF PRIMARY KEY REFERENCES PersonFile, Department varchar(50) not null ) CREATE VIEW PUD AS SELECT P.PersonalFile, U.University, D.Department FROM PersonalFile P, University U, Department D WHERE (P.PersonalFile = U.PersonalFile) and (P.PersonalFile = D.PersonalFile) CREATE TRIGGER Trig_PUD ON PUD INSTEAD OF INSERT AS BEGIN INSERT INTO PersonalFile(PersonalFile) SELECT PersonalFile FROM inserted INSERT INTO University(PersonalFile,University) SELECT University, PersonalFile FROM inserted INSERT INTO Department(PersonalFile, Department) SELECT PersonalFile, Department FROM inserted END insert into PUD(PersonalFile, University, Department) values('123445', 'Univerdity1', 'Department1') Best Regards, exceter.
-
Hi, plz, help me with the following, (the code is attached) Trying to insert, I have the following message: (1 row(s) affected) Server: Msg 8152, Level 16, State 9, Procedure Trig_PUD, Line 8 String or binary data would be truncated. The statement has been terminated. the Code is: CREATE TABLE PersonalFile ( IDnum int identity(1,1) not null, PersonalFile varchar(10) not null CONSTRAINT PK_PersonalFile PRIMARY KEY ) CREATE TABLE University ( PersonalFile varchar(10) not null CONSTRAINT PK_UniversityPF PRIMARY KEY REFERENCES PersonFile, University varchar(50) not null ) CREATE TABLE Department ( PersonalFile varchar(10) not null CONSTRAINT PK_DepartmentPF PRIMARY KEY REFERENCES PersonFile, Department varchar(50) not null ) CREATE VIEW PUD AS SELECT P.PersonalFile, U.University, D.Department FROM PersonalFile P, University U, Department D WHERE (P.PersonalFile = U.PersonalFile) and (P.PersonalFile = D.PersonalFile) CREATE TRIGGER Trig_PUD ON PUD INSTEAD OF INSERT AS BEGIN INSERT INTO PersonalFile(PersonalFile) SELECT PersonalFile FROM inserted INSERT INTO University(PersonalFile,University) SELECT University, PersonalFile FROM inserted INSERT INTO Department(PersonalFile, Department) SELECT PersonalFile, Department FROM inserted END insert into PUD(PersonalFile, University, Department) values('123445', 'Univerdity1', 'Department1') Best Regards, exceter.