jspc
asked on
SQL Trigger Max Length
Hello,
I have the below trigger which works fine. I want to amend the trigger to only INSERT a maximum length of 30 characters. Can you please assist?
CREATE TRIGGER TRANSHEADERS_CustomerRef_U pdate
ON Transheaders
FOR INSERT AS
BEGIN
UPDATE TRANSHEADERS
Set ZCustomerRef = ExtraText
Where AccountID = 'CAWWWEBXXXX' AND TransactionType = 'CO'
END
I have the below trigger which works fine. I want to amend the trigger to only INSERT a maximum length of 30 characters. Can you please assist?
CREATE TRIGGER TRANSHEADERS_CustomerRef_U
ON Transheaders
FOR INSERT AS
BEGIN
UPDATE TRANSHEADERS
Set ZCustomerRef = ExtraText
Where AccountID = 'CAWWWEBXXXX' AND TransactionType = 'CO'
END
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.