34,593
社区成员
发帖
与我相关
我的任务
分享
-- =============================================
-- 日期格式检测
-- =============================================
IF EXISTS (SELECT name
FROM sysobjects
WHERE name = N'tr_checkDate'
AND type = 'TR')
DROP TRIGGER tr_checkDate ;
GO
CREATE TRIGGER [dbo].[tr_checkDate]
ON TABLE1
INSTEAD OF DELETE, INSERT, UPDATE
AS
BEGIN
DECLARE @COL1 CHAR(5)
SELECT @COL1=COL1 FROM INSERTED WHERE COL1 LIKE '__:__'
IF @COL1 IS NULL
PRINT '插入或者更新时候 格式出错!!!!'
END
GO