DECLARE @NUM INT; SELECT @NUM=ID FROM ACCOUNT; INSERT INTO USER VALUES('YH','MA',@NUM); 转载于:https://www.cnblogs.com/xcblog/p/3564144.html