alter procedure testd
@tablename varchar(255)
as
declare @sql_str varchar(4000)
select @sql_str='select * from '+@tablename
exec(@sql_str)
@tablename varchar(255)
as
declare @sql_str varchar(4000)
select @sql_str='select * from '+@tablename
exec(@sql_str)
@tablename varchar(255)
as
declare @sql_str varchar(4000)
select @sql_str='select * from '+@tablename
exec(@sql_str)调用 test 'tablename'
@变量A varchar(100)
as
declare @sql varchar(8000)
set @='select * from '+@变量A
exec(@)
go
CABO(白椒腊肉) 、 pengdali(大力)