CREATE TRIGGER tri_test
ON tb2
AFTER INSERT
AS
UPDATE tb1 SET
jsr_name1=(SELECT TOP 1 jsr_name1 FROM tb2 GROUP BY jsr_name1 ORDER BY COUNT(*) DESC),
jsr_name1=(SELECT TOP 1 jsr_name2 FROM tb2 GROUP BY jsr_name2 ORDER BY COUNT(*) DESC)
GO
ON tb2
AFTER INSERT
AS
UPDATE tb1 SET
jsr_name1=(SELECT TOP 1 jsr_name1 FROM tb2 GROUP BY jsr_name1 ORDER BY COUNT(*) DESC),
jsr_name1=(SELECT TOP 1 jsr_name2 FROM tb2 GROUP BY jsr_name2 ORDER BY COUNT(*) DESC)
GO
解决方案 »
- 关于SQL中exists筛选的问题
- 各位大哥,大姐:为什么SQL2000安装不上呀!在线等……详细如下:
- SELECT SUM(IF (DATEDIFF(n, server_date,server_finish_date) > 240 THEN ww = 240 ELSE ww = (DATEDIFF(n, server_date,server_finish_
- 高手请进:疑难杂症
- 请教高手——问一个幼稚的问题。如何在Deleted和Inserted表中取得上一次影响记录的某个字段,谢谢:)
- 请高手帮忙:n/a表示什么意思?
- 再次提出,如何查询多单位数据,未解决,急!
- sql server2000中存储过程中的输出参数如何传到外部变量中使用?
- SQL语句
- 如何写触发器???救命阿
- 紧急求助!SqlServer 2008 链接 SqlServer2000服务器问题
- 存储过程出了点问题?不知道那里错了?
for insert
as
begin
update tb1
set
jsr_name1=(select top 1 jsr_name1 from (select jsr_name1,count(1) as num from trg_tb2 group by jsr_name1) order by num desc),
jsr_name2=(select top 1 jsr_name2 from (select jsr_name2,count(1) as num from trg_tb2 group by jsr_name2) order by num desc),
end