表tUser:
Usercode
aaa
bbb
ccc
sss
表:tUser2User
Usercode ToUsercode
sss bbb
sss ccc
sss sss 第一张是用户表, 第二张是用户的好友表, 现在要把表1所有的用户都加为sss这个用户的好友~
Usercode
aaa
bbb
ccc
sss
表:tUser2User
Usercode ToUsercode
sss bbb
sss ccc
sss sss 第一张是用户表, 第二张是用户的好友表, 现在要把表1所有的用户都加为sss这个用户的好友~
select 'sss',Usercode
from tUser
where Usercode<>'sss'
SELECT 'SSS',Usercode FROM tUser WHERE Usercode <> 'sss'
insert into tUser2User
select 'sss','aaa'
--> (让你望见影子的墙)生成测试数据,时间:2009-02-12
if not object_id('tb') is null
drop table tb
Go
Create table tb([Usercode] nvarchar(3))
Insert tb
select N'aaa' union all
select N'bbb' union all
select N'ccc' union all
select N'sss'
Go
Select * from tb--> (让你望见影子的墙)生成测试数据,时间:2009-02-12
if not object_id('tb2') is null
drop table tb2
Go
Create table tb2([Usercode] nvarchar(3),[ToUsercode] nvarchar(3))
Insert tb2
select N'sss',N'bbb' union all
select N'sss',N'ccc' union all
select N'sss',N'sss'
Go
Select * from tb2
insert into tb2
select 'sss',tb.usercode
from tb left join tb2 on tb.usercode=tousercode
where tousercode is nullselect * from tb2sss bbb
sss ccc
sss sss
sss aaa
select 'sss', usercode, 0 from tUser where usercode not in (select ToUsercode from tUser2User where usercode='sss')