用一个触发器,当超过10000时,提示create trigger name for ... as if count(id)>10000 begin showmessage('!!!!!!!!!') end
begin query.clear; query.sql.add('select * from table'); open; if query.recordcount>=10000 then messagedlg('满10000',mtinformation,[mbok],0); end;
begin query.clear; query.sql.add('select * from table'); open; if query.recordcount>=10000 then messagedlg('满10000',mtinformation,[mbok],0); end;
to beyondtkl(大龙驹<逝追>) 这位大虾,能不能给个服务器写一小程序的例子呀??
to beyondtkl(大龙驹<逝追>) 这位大虾,能不能给个服务器写一小程序的例子呀??
to beyondtkl(大龙驹<逝追>) 这位大虾,能不能给个服务器写一小程序的例子呀??
各位大虾 帮忙啦,好像oracle有这样的功能,sql server有没有阿????
写个触发器,代码如下 [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
as
if count(id)>10000
begin
showmessage('!!!!!!!!!')
end
query.clear;
query.sql.add('select * from table');
open;
if query.recordcount>=10000 then
messagedlg('满10000',mtinformation,[mbok],0);
end;
query.clear;
query.sql.add('select * from table');
open;
if query.recordcount>=10000 then
messagedlg('满10000',mtinformation,[mbok],0);
end;
帮忙啦,好像oracle有这样的功能,sql server有没有阿????
[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
IF @ROWCOUNT >1
应该改成
IF @ROWCOUNT >10000