将一个字段作为下一行放置到另一字段 [英] To place one field as next line to another field

问题描述

我在表中有两个字段address1和address2.在我的结果集中，我需要第一行中的address1和第二行中的address2.如何在Sql Server 2005中进行查询.请帮助我. Beena.

Hi,
I have two fields address1 and address2 in a table.In my resultset i need address1 in first line and address2 in second line.How will be the query in Sql server 2005.Please help me.Thanks in advance.
Beena.

推荐答案

select Address1 + CHAR(13) + CHAR(10)+ Address2
from SomeTable

您可以使用 ^ ]

这是一个例子

You can do this using Union[^]

Here is an example

CREATE TABLE #Address
(
	ID INT,
	Address1 VARCHAR(50),
	Address2 VARCHAR(50)
)

INSERT INTO #Address
SELECT 1, 'PO BOX 660629', 'SUITE A'


SELECT Address1 AS Address, 1 AS [Order]
FROM #Address
WHERE ID = 1
UNION
SELECT Address2 AS Address, 2 AS [Order]
FROM #Address
WHERE ID = 1
ORDER BY [Order]


DROP TABLE #Address

这篇关于将一个字段作为下一行放置到另一字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！