写个触发器,代码如下
[dbo].[test] -- 你需要校验的表名
RecordCheck-- 触发器名字
-------------------------------
CREATE TRIGGER RecordCheck ON [dbo].[test]
FOR INSERT
AS
DECLARE
@ROWCOUNT INT
BEGIN
SELECT @ROWCOUNT = COUNT(*) FROM TEST
IF @ROWCOUNT >1
RAISERROR ('超过了1000条记录,请注意啦.', 16, 1)
END