DECLARE @re VARCHAR(8000);
SET @re='';SELECT
@re=@re+contect1+'/'
FROM tbASELECT
@re=@re+conect2+'/'
FROM tbBSET @re=LEFT(@re,LEN(@re)-1);SELECT @re
SET @re='';SELECT
@re=@re+contect1+'/'
FROM tbASELECT
@re=@re+conect2+'/'
FROM tbBSET @re=LEFT(@re,LEN(@re)-1);SELECT @re
create table B(sn2 int, contect2 varchar(10))
insert into a values(1 , '你好')
insert into a values(2 , '很好')
insert into a values(3 , '一般情况')
insert into a values(4 , '是还可以')
insert into a values(5 , '确实不错')
insert into b values(1 , '可以的')
insert into b values(2 , '你好嘛')
godeclare @output1 varchar(8000)
select @output1 = coalesce(@output1 + '/' , '') + contect1 from a
declare @output2 varchar(8000)
select @output2 = coalesce(@output2 + '/' , '') + contect2 from bprint @output1 + '/' + @output2drop table a , b/*
你好/很好/一般情况/是还可以/确实不错/可以的/你好嘛
*/
可以不将打印出来 转到C表help字段上去呢 帮忙再写写哈
create table A(sn1 int, contect1 varchar(10))
create table B(sn2 int, contect2 varchar(10))
insert into a values(1 , '你好')
insert into a values(2 , '很好')
insert into a values(3 , '一般情况')
insert into a values(4 , '是还可以')
insert into a values(5 , '确实不错')
insert into b values(1 , '可以的')
insert into b values(2 , '你好嘛')
create table c(help varchar(100))
godeclare @output1 varchar(8000)
select @output1 = coalesce(@output1 + '/' , '') + contect1 from a
declare @output2 varchar(8000)
select @output2 = coalesce(@output2 + '/' , '') + contect2 from binsert into c values( @output1 + '/' + @output2)select * from cdrop table a , b , c/*
help
----------------------------------------------------------------------------------------------------
你好/很好/一般情况/是还可以/确实不错/可以的/你好嘛(所影响的行数为 1 行)
*/
create table B(sn2 int, contect2 varchar(10))
insert into a values(1 , '你好')
insert into a values(2 , '很好')
insert into a values(3 , '一般情况')
insert into a values(4 , '是还可以')
insert into a values(5 , '确实不错')
insert into b values(1 , '可以的')
insert into b values(2 , '你好嘛')
create table c(help varchar(100))
godeclare @output1 varchar(8000)
select @output1 = coalesce(@output1 + '/' , '') + contect1 from a
declare @output2 varchar(8000)
select @output2 = coalesce(@output2 + '/' , '') + contect2 from binsert into c values( @output1 + '/' + @output2)select * from cdrop table a , b , c
上面的情况,还有个问题是 如果@autput1为空的时候 那么最终就没有结果了 但是@output2有包换有字段 所有还可不可以再写一下 当@output1不管有没有值 他都会得到结果出来