＋设为首页 ＋添加到收藏夹
我想选取出一行数据后把它们都存到一列里。
比如：
把下面的结果集存入另一个表的data列
——————————————————————————————
job_id job_desc min_lvl max_lvl
1 New Hire - Job not specified 10 10
——————————————————————————————
最后的结果应是这个样子：
data
1
New Hire - Job
not specified
10
10
谢谢大家！
動態SQL.
(1)、
USE Northwind
GO
Create table tmpMy(tt varchar(8000)) /*要插入的table*/
Declare @t varchar(8000)
set @t=
Select top 1 @t=@t+cast(OrderID as varchar)+char(11)+cast(CustomerID as varchar)+char(11)+cast(OrderDate as varchar) From Orders
set @t= SET QUOTED_IDENTIFIER OFF INSERT INTO tmpMy Select "+replace(@t,char(11)," INSERT INTO tmpMy Select ")+"
exec (@t)
Select * from tmpMy
Drop table tmpMy
笨法子：
Create table etable
(data varchar(100))
insert etable select cast(job_id as varchar) from table_name
insert etable select cast(job_desc as varchar) from table_name
insert etable select cast(min_lvl as varchar) from table_name
insert etable select cast(max_lvl as varchar) from table_name
