34,594
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE dbo.GetInfoByEventID
@EventID varchar(50)
AS
declare @tblname varchar(30)
declare @eventtypeid int
select @eventtypeid=eventtypeid from a_event where eventid=@EventID
select @tblname=tablename from a_eventtype where eventtypeid=@eventtypeid
print @tblname
declare @sql varchar(255)
set @sql='SELECT eventtypeid, '+@tblname+'. * FROM '+@tblname+',a_event where a_event.eventid='+@EventID+' and '+@tblname+'.eventid=a_event.eventid'
exec(@sql)
GO
strQry.SQL.Text := 'GetInfoByEventID ' + csEventID