CREATE PROCEDURE jobintentselect
@pid int,
@tablename varchar(64)
AS
declare @str varchar(2000)
set @str='select * from '+@tablename+' where pid= '+cast(@pid as varchar(32))
@pid int,
@tablename varchar(64)
AS
declare @str varchar(2000)
set @str='select * from '+@tablename+' where pid= '+cast(@pid as varchar(32))
@pid int,
@tablename varchar(64)
AS
declare @str varchar(2000)
set @str ='select * from '+@tablename+' where pid= '+cast(@pid as varchar(32))
exec(@str)
@pid int,
@tablename varchar(64)
AS
declare @sql nvarchar(2000)
set @sql ='select * from '+@tablename+' where pid= '+@pid
exec(@str)
@pid int,
@tablename varchar(64)
AS
declare @sql nvarchar(2000)
set @sql ='select * from '+@tablename+' where pid= '+@pid
exec(@sql)