--试试这样改触发器:CREATE TRIGGER [useriddetet] ON [dbo].[USERID]
FOR update
AS
delete c
from c join deleted d on c.userid=d.userid insert c (userid,formtag,buttontag)
select userid, formtag,buttontag
from b join inserted i on b.rolecode=i.rolecode
FOR update
AS
delete c
from c join deleted d on c.userid=d.userid insert c (userid,formtag,buttontag)
select userid, formtag,buttontag
from b join inserted i on b.rolecode=i.rolecode
解决方案 »
- 今天找到了解锁sql server2005的存储过程,但不知道如何运行?
- 常用sql:过滤重复数据查询如何写
- 求:可以跳过用select查询时候的sql的报错,把表里面的内容都查询或导出来的工具??
- 關於多表查詢匯總的問題
- 一个sql查询赋值给字符串的问题
- 高手进:求最值,并指出最值出现位置!
- 关于数据库名的简单问题
- 本地ACCESS库改为远程SQL SERVER7时,使用VB的DA0开发,如果报这个错如何处理?出错号是:3073,具体见内容
- 急!!!如何在asp.net中把excel文件中的数据导入sql2000
- 如何建立对应的odbc数据源?
- sp_executesql问题 (在线等待)
- 在线等待。。。!同一条记录的不同字段求和问题!???
怎么你的触发器用了?:
from b where rolecode=@userid
select @userid=userid from deleted select @userid=rolecode from inserted
不知道sqlserver支持不支持。按照你写的触发器我试了出现同样的错误
还是出现同样的错误,
我也试了,如果把触发拿掉保存一切ok。
for insert?
CREATE TABLE [USERID] (
[USERNAME] [varchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[USERID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ROLECODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[REMARKS] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
[SUPPERMANAGER] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
[SCOPECODE] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[DEPARTNO] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ENABLE] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[PASSWORD] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[CREATER] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
[CREATEDATE] [datetime] NULL ,
[MODIFIER] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
[MODIFYDATE] [datetime] NULL ,
CONSTRAINT [PK_USERID] PRIMARY KEY CLUSTERED
(
[USERID]
) ON [PRIMARY] ,
CONSTRAINT [IX_USERID_1] UNIQUE NONCLUSTERED
(
[USERNAME],
[USERID]
) ON [PRIMARY]
) ON [PRIMARY]