首先你的tUser的ID是否是自增的,如果不是自增的就用触发器:如果是自增的就用存储过程:create trigger addUser on tUser for insert as begin declare @ID char(10) declare @name char(10) select @cno=[ID],@name=[name] from inserted insert into tSafe (ID,UserID) values(@ID,@name) end
CREATE PROCEDURE [dbo].[usp_InsertTeam]
@Name char(10)
AS
begin
declare @newnum int
INSERT INTO [tUser] VALUES (@Name )
set @newnum=@@IDENTITY
INSERT INTO [tSafe] (ID,UserID) values(@newnum,@Name )
end
go