create proc p_test
@level int
as
declare @tablename sysname
if @level=1
set @tablename='school'
else
set @tablename='xxx'
exec('select * from '+@tablename)
go--调用示例
exec p_test 1
@level int
as
declare @tablename sysname
if @level=1
set @tablename='school'
else
set @tablename='xxx'
exec('select * from '+@tablename)
go--调用示例
exec p_test 1
create proc p_test
@level int
as
if @level=1
select * from school
else
select * from xxx
go