存储过程的问题.

[ljren_t]

select @Name=name,@tID=parentID from area where ID= @tID
表名我想用变量,可这样写出错.
select @Name=name,@tID=parentID from @tType where ID= @tID
应该怎么写?

[guasha]

select @sql='......'
exec(@sql)

[net_steven]

动态sql:
declare @csql varchar(200)
select @csql='declare @Name varchar(50),@tID int '
select @csql=@csql+'select @Name=name,@tID=parentID from '+@tType+'where ID= '+cast(@tID as varchar(50))
execute(@csql)

[tommychim]

Declare @SQL NVarchar(500),@Table_Name Varchar(20),@Filtered Char(2)
Select @Table_Name='vcrRepairDetail'
Select @Filtered='11'
Select @SQL='Select * From '+@Table_Name+' Where DocNo Like '''+@Filtered+'%'''
Exec sp_executesql @SQL

[tommychim]

declare @name varchar(20),@tid int,@tablename varchar(20),@sql nvarchar(800)
set @sql ='select @name=name,@tid=parentid from '+@tablename+' where id=@tid'
execute sp_executesql @sql,N'@name varchar(20) output,@tid int output',
@p1 output,@p2 output
print @p1
print @p2

[ljren_t]

谢谢各位.