34,594
社区成员
发帖
与我相关
我的任务
分享
insert into [user] select '004' , 'Mike',max(PartyID) ,PartyName from Party group by partyname where PartyName = 'AC'
insert into [user] select '004' , 'Mike',PartyID ,PartyName
from party
where PartyName = 'AC'
if object_id('[User]') is not null drop table [User]
go
create table [User](UserID varchar(10),UserName varchar(10),Party varchar(10),PartyName varchar(10))
insert into [User] values('001', 'John', '000001', 'DV')
insert into [User] values('002', 'Leo' , '000002', 'AC')
insert into [User] values('003', 'Ken' , '000003', 'KE')
go
if object_id('Party') is not null drop table Party
go
create table Party(PartyID varchar(10),PartyName varchar(10))
insert into Party values('000001', 'DV')
insert into Party values('000002', 'AC')
insert into Party values('000003', 'KE')
go
insert into [user]
select '004' , 'Mike',PartyID ,PartyName from party where PartyName = 'AC'
select * from [user]
UserID UserName Party PartyName
---------- ---------- ---------- ----------
001 John 000001 DV
002 Leo 000002 AC
003 Ken 000003 KE
004 Mike 000002 AC
(4 行受影响)
if object_id('[User]') is not null drop table [User]
go
create table [User](UserID varchar(10),UserName varchar(10),Party varchar(10),PartyName varchar(10))
insert into [User] values('001', 'John', '000001', 'DV')
insert into [User] values('002', 'Leo' , '000002', 'AC')
insert into [User] values('003', 'Ken' , '000003', 'KE')
go
if object_id('Party') is not null drop table Party
go
create table Party(PartyID varchar(10),PartyName varchar(10))
insert into Party values('000001', 'DV')
insert into Party values('000002', 'AC')
insert into Party values('000003', 'KE')
go
insert into [user]
select '004' , 'Mike',PartyID ,PartyName from party where PartyName = 'AC'
select * from [user]
UserID UserName Party PartyName
---------- ---------- ---------- ----------
001 John 000001 DV
002 Leo 000002 AC
003 Ken 000003 KE
004 Mike 000002 AC
(4 行受影响)
create table [User](UserID varchar(10),UserName varchar(10),Party varchar(10),PartyName varchar(10))
insert into [User] values('001', 'John', '000001', 'DV')
insert into [User] values('002', 'Leo' , '000002', 'AC')
insert into [User] values('003', 'Ken' , '000003', 'KE')
create table Party(PartyID varchar(10),PartyName varchar(10))
insert into Party values('000001', 'DV')
insert into Party values('000002', 'AC')
insert into Party values('000003', 'KE')
go
insert into [user] select '004' , 'Mike',PartyID ,PartyName from party where PartyName = 'AC'
select * from [user]
/*
UserID UserName Party PartyName
---------- ---------- ---------- ----------
001 John 000001 DV
002 Leo 000002 AC
003 Ken 000003 KE
004 Mike 000002 AC
(所影响的行数为 4 行)
*/
drop table [user],party
insert into [user]
select '004','Mike', partyid,partyname from party where partyname='AC'
insert into [user] select '004' , 'Mike',PartyID ,PartyName from party where PartyName = 'AC'
insert into [user] select '004' , 'Mike',PartyID ,PartyName from Party where PartyName = 'AC'
if object_id('[User]') is not null drop table [User]
go
create table [User](UserID varchar(10),UserName varchar(10),Party varchar(10),PartyName varchar(10))
insert into [User] values('001', 'John', '000001', 'DV')
insert into [User] values('002', 'Leo' , '000002', 'AC')
insert into [User] values('003', 'Ken' , '000003', 'KE')
go
if object_id('Party') is not null drop table Party
go
create table Party(PartyID varchar(10),PartyName varchar(10))
insert into Party values('000001', 'DV')
insert into Party values('000002', 'AC')
insert into Party values('000003', 'KE')
go
insert into [user]
select '004' , 'Mike',PartyID ,PartyName from party where PartyName = 'AC'
select * from [user]
UserID UserName Party PartyName
---------- ---------- ---------- ----------
001 John 000001 DV
002 Leo 000002 AC
003 Ken 000003 KE
004 Mike 000002 AC
(4 行受影响)
declare @UserID int
declare @UserName varchar(20)
declare @PartyName varchar(20)
insert into User values(@UserID,@UserName,(select PartyID from Party
where PartyName=@PartyName),@PartyName)