lapucca
asked on
how to fix error with this vague msg?
How can I find out which column to fix? Thank you.
(58 row(s) affected)
Msg 8152, Level 16, State 4, Line 12
String or binary data would be truncated.
The statement has been terminated.
(58 row(s) affected)
Msg 8152, Level 16, State 4, Line 12
String or binary data would be truncated.
The statement has been terminated.
if exists (
select * from tempdb.dbo.sysobjects o
where o.xtype in ('U')
and o.id = object_id(N'tempdb..#tempNonExistDoctors')
)
DROP TABLE #tempNonExistDoctors;
select * into #tempNonExistDoctors from dbo.Doctors
where personID is null;
INSERT INTO [MedDb].[dbo].[person]
([Employee_Last_Name]
,[Employee_First_Name]
,[Employee_Middle_Name]
,[Title]
,[Clinical_Narrative]
,[Best_Doctor]
,Web_address
,[appt_emails])
Select lastname, First_Name, MiddleName,credentials,bio,best_doctor, links, appt_emails from #tempNonExistDoctors
DROP TABLE #tempNonExistDoctors;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER