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