CREATE TRIGGER [TRIGGER NAME] ON [dbo].[jobs] FOR INSERT AS INSERT INTO YOUTABLE (FIELDNAME) SELECT CASE WHEN LEN(FIELDNAME) = 1 THEN '00000' + FIELDNAME CASE WHEN LEN(FIELDNAME) = 2 THEN '0000' + FIELDNAME CASE WHEN LEN(FIELDNAME) = 3 THEN '000' + FIELDNAME CASE WHEN LEN(FIELDNAME) = 4 THEN '00' + FIELDNAME CASE WHEN LEN(FIELDNAME) = 5 THEN '0' + FIELDNAME CASE WHEN LEN(FIELDNAME) = 6 THEN FIELDNAME END FROM inserted 笨了一点,应该能用
FOR INSERT
AS
INSERT INTO YOUTABLE (FIELDNAME)
SELECT CASE WHEN LEN(FIELDNAME) = 1 THEN '00000' + FIELDNAME
CASE WHEN LEN(FIELDNAME) = 2 THEN '0000' + FIELDNAME
CASE WHEN LEN(FIELDNAME) = 3 THEN '000' + FIELDNAME
CASE WHEN LEN(FIELDNAME) = 4 THEN '00' + FIELDNAME
CASE WHEN LEN(FIELDNAME) = 5 THEN '0' + FIELDNAME
CASE WHEN LEN(FIELDNAME) = 6 THEN FIELDNAME END
FROM inserted
笨了一点,应该能用