sql ¶àÐÐͬһ×ֶΠƴ½Ó×Ö·û´®

ÎÒͨ¹ýSELECT²é³öÁË·ûºÏÌõ¼þµÄÁУ¬ÏÖÔÚÎÒÒª°ÑËüÆ´½Ó³ÉÒ»¸ö×Ö·û´®Ôõô×ö
±ÈÈç×ֶΠA
        DDD
        AAA
ÎÒÏÖÔÚҪƴ½Ó³ÉÒ»Ìõ×Ö·û´®Öм䲻ÄÜÓУ¬ºÅ

---

SQL code:
declare @s varchar(100)
select @s=isnull(@s+'','')+col from tb
select @s

---

SQL code:
--> Éú³É²âÊÔÊý¾Ý±í:tb

If not object_id('[tb]') is null
Drop table [tb]
Go
Create table [tb]([A] nvarchar(3))
Insert [tb]
Select N'DDD' union all
Select N'AAA'
Go
--Select * from [tb]

-->SQL²éѯÈçÏÂ:
declare @s varchar(50)
select @s=isnull(@s,'')+A from tb
select @s
/*
--------------------------------------------------
DDDAAA

(1 ÐÐÊÜÓ°Ïì)
*/

---

SQL code:
-->Title:Generating test data
-->Author:wufeng4552
-->Date :2009-09-30 15:41:31

if not object_id('tb') is null
drop table tb
Go
Create table tb([test] nvarchar(3))
Insert tb
select N'A' union all
select N'DDD' union all
select N'AAA'
Go
declare @s varchar(100)
select @s=isnull(@s+'','')+test from tb
select @s
/*
-------------------------------------------------------------
ADDDAAA

*/

{{--