I am trying to use an insert trigger by mirroring inserts into Orders table towards an Orders_arch table that has the same DDL structure . I am getting a String or binary data would be truncated error on the status field, but the data i am entering I am maknig sure is not more than 50 characters :
TABLE dbo.orders
(
OrderID (pk, int, NOT NULL),
CustomerID varchar(5) NOT NULL,
trackid (varchar(50) NOT NULL),
Status varchar(50) null,
Ordershipped datetime NULL,
Orderarrived datetime NULL
CONSTRAINT PK_OrderID PRIMARY KEY CLUSTERED (OrderID ASC)
);
USE [mydb]
GO
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[trInsert] on [dbo].[Orders]
FOR INSERT
AS declare @trackid varchar(50),@custid varchar(5),
@status varchar(50), @ordershipped datetime;
select @trackid=i.trackid from inserted i;
select @custid=i.customer from inserted i;
select @status=i.status from inserted i;
select @ordershipped=i.rdershipped from inserted i;
insert into orders_arch(trackid,custid
,status,ordershipped)
values (@trackid,@custid,@status,@ordershipped);
???
Thanks in advance