小弟我把用户信息放在两张表中，怎么同时插入信息
日期：2014-05-17 浏览次数：20546 次
我把用户信息放在两张表中，如何同时插入信息？
------最佳解决方案--------------------
方法1：
--表的结构大概是这样的 [Tab_Details]的[UserID]是外键
CREATE TABLE [dbo].[Tab_User](
[UserID] [int] IDENTITY(1,1)PRIMARY KEY,
[UserName] [nvarchar](50) NOT NULL,
[UserPassword] [nvarchar](50) NOT NULL,
[UserAge] [int] NOT NULL,
[UserBirthday] [datetime] NOT NULL,
[UserGongzi] [money] NULL,
[UserSex] [bit] NOT NULL,
[UserCityID] [int] NOT NULL,
)
CREATE TABLE [Tab_Details](
[DetailsID] [int]IDENTITY(1,1) PRIMARY KEY,
[UserID] [int]FOREIGN KEY REFERENCES Tab_User(UserID) ,--
[UserIP] [varchar](50),
[UserLastLoginTime] [datetime] NOT NULL ,
[UserPhone] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[UserEMail] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[UserTouxiang] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
)
--我想这么写却报错！
INSERT INTO Tab_Details
(UserID,UserIP,UserLastLoginTime,UserPhone,UserEMail,UserTouxiang)
VALUES(
INSERT INTO Tab_User
(UserName,UserPassword,UserAge,UserBirthday,UserGongzi,UserSex,UserCityID)OUTPUT INSERTED.UserID
VALUES('郭德纲','1234',38,1974-11-13,100000,1,1),
'119.119.119.119',2012-11-11,'13888888888','360@qq.com''http://xx.com/1.jpg'
);
------最佳解决方案--------------------
方法1：
--表的结构大概是这样的 [Tab_Details]的[UserID]是外键
CREATE TABLE [dbo].[Tab_User](
[UserID] [int] IDENTITY(1,1)PRIMARY KEY,
[UserName] [nvarchar](50) NOT NULL,
[UserPassword] [nvarchar](50) NOT NULL,
[UserAge] [int] NOT NULL,
[UserBirthday] [datetime] NOT NULL,
[UserGongzi] [money] NULL,
[UserSex] [bit] NOT NULL,
[UserCityID] [int] NOT NULL,
)
CREATE TABLE [Tab_Details](
[DetailsID] [int]IDENTITY(1,1) PRIMARY KEY,
[UserID] [int]FOREIGN KEY REFERENCES Tab_User(UserID) ,--
[UserIP] [varchar](50),
[UserLastLoginTime] [datetime] NOT NULL ,
[UserPhone] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[UserEMail] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[UserTouxiang] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
)
DECLARE @id INT
INSERT INTO Tab_User
( UserName ,
UserPassword ,
UserAge ,
UserBirthday ,
UserGongzi ,
UserSex ,
&nbs
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
