我写的一个存储过程建立动态临时库并调用
CREATE PROC order_unsub_search
@tablename nvarchar(100)
AS
BEGIN

declare @createtable nvarchar(500) --建立动态临时库
set @createtable='select * into '+ rtrim(@tablename)+' from c_order_detail '

exec(@createtable)

declare @usertable nvarchar(1000) --调用临时库

set @usertable='select * from '+ rtrim(@tablename)

exec(@usertable)

END


GO


[解决办法]

SQL code

...asbegin--得提前判断这个表存不存在，存在就必须删了    if object_id(@tablename) is not null        exec('drop table '+@tablename)...end