有2個表
表一:Users
UserID int identity(1,1),
UserName nvarchar(20)
表二:UsersInGroup
UserID int,
GroupID int觸發器如何
CREATE TRIGGER UserAdd_Insert
ON [Users]
FOR Insert
AS
Declare @UserID int
Select @UserID from Inserted
Insert into UsersInGroup([UserID],[GroupID])
Select @UserID,1我在程序中添加Users紀錄時,會提示 Cannot insert the value into column 'UserID',Table 'UsersInGroup';column does not allow nulls.
不知應該如何寫這個觸發器?謝謝
表一:Users
UserID int identity(1,1),
UserName nvarchar(20)
表二:UsersInGroup
UserID int,
GroupID int觸發器如何
CREATE TRIGGER UserAdd_Insert
ON [Users]
FOR Insert
AS
Declare @UserID int
Select @UserID from Inserted
Insert into UsersInGroup([UserID],[GroupID])
Select @UserID,1我在程序中添加Users紀錄時,會提示 Cannot insert the value into column 'UserID',Table 'UsersInGroup';column does not allow nulls.
不知應該如何寫這個觸發器?謝謝
ON [Users]
FOR Insert
AS
Insert into UsersInGroup([UserID],[GroupID])
Select UserID,1 as GroupID
from inserted