CREATE TRIGGER updatedate ON [dbo].[price]
FOR INSERT, UPDATE
AS

IF @@ROWCOUNT >0
BEGIN

UPDATE p SET p.code=i.code,p.name=i.name from price2 as p,Inserted as i WHERE i.stock_code=p.stock_code
INSERT into price2 select * from inserted where inserted.code not in (select code from price2)

END

如果price表的某条记录更新，则price2表也更新。
如果price表有添加了新的记录，则把新加的记录添加到price2表

-----------------------------------------------------------

CREATE TRIGGER renjpname ON [dbo].[price2]
FOR INSERT, UPDATE
AS

DECLARE @scode varchar(6)
IF @@ROWCOUNT >0
BEGIN

-- 取得当前被更新的stock_code，Inserted 表用于存储INSERT 和UPDATE 语句所影响的行的副本。
SELECT @scode=stock_code FROM Inserted

-- 然后更新时间
--UPDATE price2 SET stock_name =(select stock_name from jpname where )
UPDATE price2 SET stock_name =(select stock_name from jpname where ) where

END