user表:( 都有预设值)如:userid name dep telephone
1 张三 研发部 8001
2 李四 财务部 9001userdata表:
id userid name dep telephone ipaddress sysdate prio
我想往userdata表提交插入数据时,user表的name,dep telephone 同时复制插入userdata表.
1 张三 研发部 8001
2 李四 财务部 9001userdata表:
id userid name dep telephone ipaddress sysdate prio
我想往userdata表提交插入数据时,user表的name,dep telephone 同时复制插入userdata表.
insert [user] select 1, '张三', '研发部', '8001'
union all select 2, '李四', '财务部', '9001'create table userdata(id int identity(1,1), userid int, name nvarchar(10), dep nvarchar(10), telephone nvarchar(10),
ipaddress nvarchar(20), sysdate nvarchar(20), prio nvarchar(20))
create proc pc(
@userid int,
@ipaddress nvarchar(20),
@sysdate nvarchar(20),
@prio nvarchar(20)
)
as
declare @name nvarchar(10), @dep nvarchar(10), @telephone nvarchar(10)
select @name=name, @dep=dep, @telephone=telephone from [user] where userid=@userid insert userdata(userid, name, dep, telephone, ipaddress, sysdate, prio)
values(@userid, @name, @dep, @telephone, @ipaddress, @sysdate, @prio)
@userid int,
@ipaddress varchar(8000),
@sysdate varchar(8000),
@prio varchar(8000)
)
as
select @userid,name,dep,telephone, @ipaddress, @sysdate, @prio from [user] where userid=@userid insert into userdata(userid, name, dep, telephone, ipaddress, sysdate, prio)
select @userid,name,dep,telephone, @ipaddress, @sysdate, @prio from [user] where userid=@userid
@userid int,
@ipaddress varchar(8000),
@sysdate varchar(8000),
@prio varchar(8000)
)
as
insert into userdata(userid, name, dep, telephone, ipaddress, sysdate, prio)
select @userid,name,dep,telephone, @ipaddress, @sysdate, @prio from [user] where userid=@userid
[userid] [int] NOT NULL ,
[name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[dep] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[telephone] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO