sql查询

若t表有tname列。tname列存其他表名。
筛选出tname，后。从这些表名中提取，对应表的元素。怎么写SQL

---

循环.然后动态EXEC它.

---

写一下。吧

---

            用联合查询了!

---

引用

循环.然后动态EXEC它.

此人会写的！

---

动态

---

SQL code:
CREATE TABLE tb(tbname sysname,id int)
INSERT tb VALUES('表名',1);

DECUARE cur CURSOR FOR
SELECT tbname from tb WHERE id < 10;

OPEN cur;

DECLARE @tbname sysname;

FETCH NEXT from cur INTO @tbname;
WHILE @@FETCH_STATUS=0
BEGIN
EXEC('SELECT * from ['+@tbname+']');
FETCH NEXT from cur INTO @tbname;
END

CLOSE cur;
DEALLOCATE cur;

---

SQL code:


--> 测试数据：[tb]
if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([tname] varchar(3))
insert [tb]
select 'tb1' union all
select 'tb2'


declare @B char(10)
DECLARE vend_cursor CURSOR FOR
SELECT [tname]
from tb

OPEN vend_cursor

FETCH NEXT
from vend_cursor into @B

WHILE @@FETCH_STATUS =0

BEGIN
exec('select * from '+@B+'')

FETCH NEXT
from vend_cursor into @B


END CLOSE vend_cursor
DEALLOCATE vend_cursor