PubSubShowData "hs_employee_show", "init", ""
CREATE procedure hs_employee_show
(
@OprtMode varchar(10),
@KeyValue varchar(20),
@Operator varchar(10)
)
as
declare @SqlStr varchar(400)
exec hs_public_getvalue @OprtMode,@KeyValue output,'Empl_No','hsEmployee_view',@SqlStr output
exec hs_public_log @Operator,'员工管理',@KeyValue,'See'
select '' as main
exec(@SqlStr)
GO
CREATE procedure hs_public_getvalue
(
@OprtMode varchar(10),
@KeyValue varchar(50) output,
@KeyField varchar(50),
@TableName varchar(50),
@SqlStr varchar(400) output
)
as
if @OprtMode='INIT'
begin
set @SqlStr='select top 1 * from '+rtrim(@TableName)+' where '+rtrim(@KeyField)+'<>'''' order by '+rtrim(@KeyField)+' desc'
exec('select top 1 '+@KeyField+' as KeyField into ##TempResult from '+@TableName+' where ''''">'+@KeyField+'<>'''' order by '+@KeyField+' desc')
end
此存储过程怎么理解...急急急!!!!此存储过程怎么理解...急急急!!!!此存储过程怎么理解...急急急!!!!此存储过程怎么理解...急急急!!!!此存储过程怎么理解...急急急!!!!此存储过程怎么理解...急急急!!!!此存储过程怎么理解...急急急!!!!