SQL如何把查询出来的多个表创建成一个表

[CCCZEDH]

declare @n int
set @n=1
while @n <= 5
	begin
		select cname,semester,credit
		from course
		where cno in(select top 1 cno from course where semester = @n group by cno,credit order by credit asc)
		set @n=@n+1
	end

[吉普赛的歌]

--定义接收表变量
--字段类型你自己根据实际的来定义
DECLARE @t TABLE (
	cname NVARCHAR(20),
	semester NVARCHAR(20),
	credit NVARCHAR(20)	
)
--循环插入
declare @n int
set @n=1
while @n <= 5
BEGIN
    INSERT INTO @t(cname,semester,credit)
    select cname,semester,credit
    from course
    where cno in(select top 1 cno from course where semester = @n group by cno,credit order by credit asc)
    set @n=@n+1
END
--查询表变量
SELECT * FROM @t

[qq_37693160]

学习了，学习了

[CCCZEDH]

引用 1 楼 吉普赛的歌的回复:

--定义接收表变量
--字段类型你自己根据实际的来定义
DECLARE @t TABLE (
	cname NVARCHAR(20),
	semester NVARCHAR(20),
	credit NVARCHAR(20)	
)
--循环插入
declare @n int
set @n=1
while @n <= 5
BEGIN
    INSERT INTO @t(cname,semester,credit)
    select cname,semester,credit
    from course
    where cno in(select top 1 cno from course where semester = @n group by cno,credit order by credit asc)
    set @n=@n+1
END
--查询表变量
SELECT * FROM @t

感谢，已解决，，，，，，，

[吉普赛的歌]

引用 2 楼 CCCZEDH 的回复:

[quote=引用 1 楼 吉普赛的歌的回复:]

--定义接收表变量
--字段类型你自己根据实际的来定义
DECLARE @t TABLE (
	cname NVARCHAR(20),
	semester NVARCHAR(20),
	credit NVARCHAR(20)	
)
--循环插入
declare @n int
set @n=1
while @n <= 5
BEGIN
    INSERT INTO @t(cname,semester,credit)
    select cname,semester,credit
    from course
    where cno in(select top 1 cno from course where semester = @n group by cno,credit order by credit asc)
    set @n=@n+1
END
--查询表变量
SELECT * FROM @t

感谢，已解决，，，，，，，[/quote]
不客气，没事就结贴吧

[shoppo0505]

eh...
这个不是这么做的阿。