in delphi;
query.close;
query.sql.clear;
query.sql.add('select text from table ...');
query.open;
query.first;
while not query.eof do
begin
text1.text:=text1.text+query.fieldbyname('text').asstring;
query.next;
end;
query.close;
query.sql.clear;
query.sql.add('select text from table ...');
query.open;
query.first;
while not query.eof do
begin
text1.text:=text1.text+query.fieldbyname('text').asstring;
query.next;
end;
set rs=cn.execute("select field1 from table1 ")
do until rs.eof
text1.text=text1.text+rs.fields("field1").value
rs.movenext
loop
query.close;
query.sql.clear;
query.sql.add('select text from table ...');
query.open;
query.first;
while not query.eof do
begin
text1.text:=text1.text+';'+query.fieldbyname('text').asstring;
query.next;
end;
while not rs.EOF
text1.text=text1.text+rs.fields("field1").value
rs.MoveNext
Wend
set @r=''
select @r=字段+char(13)+char(10)+@r from 你的表
select @r将上面批处理发送给SQL Server,它给你返回表中所有查询出某字段的内容。