ÁÙʱ±íÓ붯̬SQLÓï¾äÎÊÌâ - MS-SQL Server / »ù´¡Àà

ÎÒÔÚ´æ´¢¹ý³ÌÖн¨Á¢ÁËÒ»ÕÅÁÙʱ±í£¬ÆäÖµÏëͨ¹ý¶¯Ì¬SQL¸³Öµ

declare @tabName varchar(100)
declare @sql varchar(1000)

select @sql='select * from' + @tabName --ʵ¼Ê±È½Ï¸´ÔÓ

ÎÒÏÖÔÚÏë°Ñ exec(@sql)¼Ç¼ֵдÈëÁÙʱ±í#tÖУ¬ÔõôʵÏÖ£¿

---

SQL code:
select @sql='select * into #t from' + @tabName --ʵ¼Ê±È½Ï¸´ÔÓ

---

SQL code:
create table #t(colist...)
insert #t exec(@sql)

---

SQL code:
exec('create table #tb(id int)
insert into #tb values(1)
select * from #tb
drop table #tb'
)

/*
id
-----------
1

£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
*/

---

ÒýÓÃ

SQL code
exec('create table #tb(id int)
insert into #tb values(1)
select * from #tb
drop table #tb'
)

/*
id
-----------
1

£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
*/

Òâ˼½«ËùÓеĶ«Î÷ÕûºÏ½øÒ»¸ö´®ÖÐ.

---

ÒýÓÃ

SQL code
create table #t(.....)
insert #t exec(@sql)

up...........

---

ºÃ¶àѽ

ÆäʵÁÙʱ±íÖ»ÊÇÃû×ֽз¨£¬ÔÚµ±Ç°×÷Ó