27,579
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE [dbo].[用户表](
[userid] [INT] IDENTITY(1,1) NOT NULL,
[用户名] [NVARCHAR](50) NULL,
[用户密码] [NVARCHAR](50) NULL,
CONSTRAINT [PK_用户表] PRIMARY KEY CLUSTERED
(
[userid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[登录表](
[登录名] [NVARCHAR](50) NOT NULL,
[登录密码] [NVARCHAR](50) NULL,
[Bid] [INT] NULL
) ON [PRIMARY]
GO
INSERT INTO dbo.用户表
( 用户名, 用户密码 )
VALUES ( N'测试1', -- 用户名 - nvarchar(50)
N'123' -- 密码 - nvarchar(50)
)
create TRIGGER [dbo].[tritest1] ON [dbo].[用户表]
FOR UPDATE --更新触发
AS
DECLARE @id INT;
DECLARE @name NVARCHAR(100);
DECLARE @password NVARCHAR(100);
SELECT @id = userid ,
@name = 用户名 ,
@password = 用户密码
FROM Inserted;
BEGIN
UPDATE 登录表
SET 登录名 = @name ,
登录密码 = @password
WHERE Bid = @id
END
INSERT INTO dbo.登录表
( 登录名, 登录密码, Bid )
SELECT 用户名 ,
用户密码 ,
userid
FROM dbo.用户表
UPDATE dbo.用户表 SET 用户密码 = '123456' WHERE userid=1
SELECT * FROM dbo.登录表