各位高手帮忙，触发器的问题

[liq1979]

我创建了一个触发器如下：
CREATE TRIGGER smscount ON tbl_RecieveSM FOR INSERT
AS
IF UPPER(SUBSTRING(content,1,4)) = 'DMPX'
BEGIN
UPDATE Production SET Product_Vote = Product_Vote + 1
WHERE Product_ID = SUBSTRING(content,5,6)
END
go
出错提示 content 列名无效，content是tbl_RecieveSM中的字段，我换成tbl_RecieveSM.content，也抱错：“列前缀 'tbl_RecieveSM' 与查询中所用的表名或别名不匹配。”
请大家帮忙，100分

[zjcxc]

CREATE TRIGGER smscount ON tbl_RecieveSM FOR INSERT
AS
UPDATE a SET Product_Vote=a.Product_Vote+1
FROM Production a,inserted i
where UPPER(SUBSTRING(i.content,1,4)) = 'DMPX'
and a.Product_ID=SUBSTRING(i.content,5,6)
GO

[pbsql]

CREATE TRIGGER smscount ON tbl_RecieveSM FOR INSERT
AS
UPDATE Production SET Product_Vote=Product_Vote+1
FROM inserted
WHERE Production.Product_ID=SUBSTRING(inserted.content,5,6)
and UPPER(SUBSTRING(inserted.content,1,4))='DMPX'
go

[qizhirui]

把你表tbl_RecieveSM与Production 的结构贴出来看看

[talantlee]

CREATE TRIGGER smscount ON tbl_RecieveSM FOR INSERT
AS
declare @a varchar(10)
select @a=Substring(Content,1,4) from Production
IF (UPPER(@a) = 'DMPX')
BEGIN
UPDATE Production SET Product_Vote = Product_Vote + 1
WHERE Product_ID = SUBSTRING(content,5,6)
END
go