34,590
社区成员
发帖
与我相关
我的任务
分享
ALTER TABLE Tab_Apartment ADD CHECK(LEN(RoomNo)<4)
CREATE TRIGGER [tr_Apartment_RoomNo] ON [dbo].[Tab_Apartment ]
FOR INSERT, UPDATE
AS
UPDATE Tab_Apartment
SET RoomNo = RIGHT('0000'+RTRIM(I.RoomNo), 4)
FROM Tab_Apartment P, Inserted I
WHERE P.aid = I.aid
AND LEN(I.RoomNo)<4
GO
modifyCREATE TRIGGER [tr_Apartment_RoomNo] ON [dbo].[Tab_Apartment ]
FOR INSERT, UPDATE
AS
UPDATE Tab_Apartment
SET RoomNo = RIGHT('0000'+LTRIM(RoomNo), 4)
FROM Tab_Apartment P, Inserted I
WHERE P.aid = I.aid
AND LEN(I.RoomNo)<4
GO