参数是表名,在过程中怎么select这个变量啊?急
---------------------------------------------------------------
create proc tablea (@tablename nvarchar(20))
as
declare @str char(50)
set @str='select * from '+@tablename+''
exec(@str)
go
参数是表名,在过程中怎么select这个变量啊?急
---------------------------------------------------------------
create proc tablea (@tablename nvarchar(20))
as
declare @str char(50)
set @str='select * from '+@tablename+''
exec(@str)
go