create procedure up_MasterSlave @id char(15) -- '主表查询字段值 i.e. R20041129001' as begin declare @slave_tbl_name varchar(255) set @slave_tbl_name = null select @slave_tbl_name = [Table] from MasterTab where [ID] = @id if @slave_tbl_name is null return -1 else exec('select m.*, s.* from MasterTab m,' + @slave_tbl_name +' s where m.tab_id =' + @id) end
@id char(15) -- '主表查询字段值 i.e. R20041129001'
as
begin
declare @slave_tbl_name varchar(255)
set @slave_tbl_name = null select @slave_tbl_name = [Table]
from MasterTab
where [ID] = @id if @slave_tbl_name is null
return -1
else
exec('select m.*, s.* from MasterTab m,' + @slave_tbl_name +' s where m.tab_id =' + @id)
end
--------------------------------------
results : ---
---
---