create proc gc
@str varchar(20)
as
begin
declare @sql as varchar(100)
set @sql='select * from '+@str
exec(@sql)
end
EXEC GC 'prdt'
create proc gc
@str varchar(20)
as
begin
declare @sql as varchar(100)
set @sql='select * from '+@str
exec(@sql)
end
EXEC GC 'prdt'