急救,请各位大侠赐教!

fishidea 2010-01-20 09:12:12

表 A 如下:

cc name count
1 AA NULL
2 BB NULL
3 CC NULL
4 DD NULL

怎么能将count的值更新为 AA,BB,CC,DD ?

多谢大家指点,谢谢了~

...全文

73 12 点赞打赏收藏举报

写回复

12 条回复

切换为时间正序

当前发帖距今超过3年，不再开放新的回复

发表回复

pt1314917 2010-01-20

[Quote=引用 7 楼 fishidea 的回复:]
谢谢回复,不对噢~我要查询出来的count的值是 AA,BB,CC,DD,

按您现在的这样,count的值是等于name的,如下:
cc name count
1 AA AA
2 BB BB
3 CC CC
4 DD DD
这是错的
[/Quote]
4、5楼早有正确答案了。。。

打赏
举报

回复赞

fishidea 2010-01-20

感谢SQL77与andysun88,结贴给分!^_^

打赏
举报

回复赞

andysun88 2010-01-20



declare @strs varchar(500)

set @strs=''

select @strs = @strs +','+name from A12

print @strs



select A12.cc,A12.name,@strs as count from A12

打赏
举报

回复赞

SQL77 2010-01-20

if object_id('[A]') is not null drop table [A]

create table [A] (cc int,name varchar(2),count varchar(20))

insert into [A]

select 1,'AA',null union all

select 2,'BB',null union all

select 3,'CC',null union all

select 4,'DD',null



declare @str varchar(100)



select @str=isnull(@str+',','')+name from [A]



update A set [count]=@str WHERE [COUNT] IS NULL



select * from [A]

打赏
举报

回复赞

J1985Z 2010-01-20

update a set count=name

打赏
举报

回复赞

fishidea 2010-01-20

谢谢回复,不对噢~我要查询出来的count的值是 AA,BB,CC,DD,

按您现在的这样,count的值是等于name的,如下:
cc name count
1 AA AA
2 BB BB
3 CC CC
4 DD DD
这是错的

打赏
举报

回复赞

andysun88 2010-01-20

update A set count= name

打赏
举报

回复赞

nianran520 2010-01-20

--> 测试数据: [A]

if object_id('[A]') is not null drop table [A]

create table [A] (cc int,name varchar(2),count varchar(20))

insert into [A]

select 1,'AA',null union all

select 2,'BB',null union all

select 3,'CC',null union all

select 4,'DD',null



declare @str varchar(100)



select @str=isnull(@str+',','')+name from [A]



update A set [count]=@str



select * from [A]

打赏
举报

回复赞

pt1314917 2010-01-20



--> 测试数据: [A]

if object_id('[A]') is not null drop table [A]

create table [A] (cc int,name varchar(2),count varchar(20))

insert into [A]

select 1,'AA',null union all

select 2,'BB',null union all

select 3,'CC',null union all

select 4,'DD',null



declare @t varchar(100)

select @t=isnull(@t+',','')+name from a

update a set [count]=@t

select * from [A]