存储过程相关表

  

drop table #tempTablename

drop table  #tableresult

create table #tempTablename(id int ,tablename varchar(100))

insert into #tempTablename(id,tablename)

 

select 1,'ez_AuthenticationUser'union all

select 2,'ez_BeforeUploadCheck'union all

select 3,'ez_GetJobID'union all

select 4,'ez_GetJobList'union all

select 5,'ez_GetJudgeJobID'union all

select 6,'ez_GetJudgeList'union all

select 7,'ez_GetOperatorInformation'union all

select 8,'ez_GetOperatorResult'union all

select 9,'ez_JobmanaClear'union all

select 10,'ez_JudgeBeforeUploadCheck'union all

select 11,'ez_JudgemanaClear'union all

select 12,'ez_JudgeUpdateCompleteUpload'union all

select 13,'ez_JudgeUpdateDownLoadFinish'union all

select 14,'ez_JudgeUpdateDownLoadMiss'union all

select 15,'ez_JudgeUpdateEntryJobCancel'union all

select 16,'ez_JudgeUpdateEntryJobTimeUp'union all

select 17,'ez_Login'union all

select 18,'ez_NewPassWord'union all

select 19,'ez_UpdateCompleteUpload'union all

select 20,'ez_UpdateDownLoadFinish'union all

select 21,'ez_UpdateDownLoadMiss'union all

select 22,'ez_UpdateEntryJobCancel'union all

select 23,'ez_UpdateEntryJobTimeUp'union all

select 24,'JobDLUpdateManageJobID'union all

select 25,'JobDLUpdateManageJudgeID'union all

select 26,'JobDLUpdateManagementJobmana'union all

select 27,'JobDLUpdateManagementJudgemana'union all

select 28,'JobDLUpdateMobileStore'union all

select 29,'MastersOperatorGet'union all

select 30,'MobileCategoryAdd'union all

select 31,'MobileCategoryDel'union all

select 32,'MobileCategoryEdit'union all

select 33,'MobileCategoryGetRec'union all

select 34,'MobileDeliveryDelWk'union all

select 35,'MobileDeliveryGetAutoSendData'union all

select 36,'MobileDeliveryGetJudgeResult'union all

select 37,'MobileDeliveryGetMaJobmana'union all

select 38,'MobileDeliveryGetMaJudgemana'union all

select 39,'MobileDeliveryGetXmlData'union all

select 40,'MobileDeliveryGetXmlHead'union all

select 41,'MobileDeliveryJudgeGetXmlHead'union all

select 42,'MobileDeliverySetEntryResult'union all

select 43,'MobileDeliverySetMaJobmana'union all

select 44,'MobileDeliverySetMaJudgemana'union all

select 45,'MobileDeliverySetXml'union all

select 46,'MobileEntryJobClearWk'union all

select 47,'MobileEntryJobGetJobmana'union all

select 48,'MobileEntryJobGetJobmanaNocomp'union all

select 49,'MobileEntryJobGetMaJobmana'union all

select 50,'MobileEntryJobMakeWk'union all

select 51,'MobileEntryJobSetManagementJobmana'union all

select 52,'MobileEntryJobSetMobileJobmana'union all

select 53,'MobileEntryJobSetStore'union all

select 54,'MobileEntryJobSetWK'union all

select 55,'MobileEntryJobSetXml'union all

select 56,'MobileEntryJudgeGetJobmana'union all

select 57,'MobileEntryJudgeGetJudgemanaNocomp'union all

select 58,'MobileEntryJudgeGetMaJudgemana'union all

select 59,'MobileEntryJudgeSetJudgeJobmana'union all

select 60,'MobileEntryJudgeSetManagementJudgemana'union all

select 61,'MobileEntryJudgeSetStore'union all

select 62,'MobileGetCategory'union all

select 63,'MobileGetSystemCtrlMaster'union all

select 64,'MobileGetSystemSvrListData'union all

select 65,'MobileJudgeDeliveryGetAutoSendData'union all

select 66,'MobileJudgeGetSystemSvrListData'union all

select 67,'MobileMonitoringGetJobmana'union all

select 68,'MobileMonitoringJudgeGetJobmana'union all

select 69,'MobileMonitoringJudgeSetJobmana'union all

select 70,'MobileMonitoringSetJobmana'union all

select 71,'MobileOpeLogGetJobmana'union all

select 72,'MobileOperatorAdd'union all

select 73,'MobileOperatorDel'union all

select 74,'MobileOperatorEdit'union all

select 75,'MobileOperatorGet'union all

select 76,'MobileOperatorGetRec'union all

select 77,'MobileOperatorSearch'union all

select 78,'MobileRevBeriCheck'union all

select 79,'MobileRevDelWk'union all

select 80,'MobileRevGetAutoMakeData'union all

select 81,'MobileRevGetAutoMakeDataCheck'union all

select 82,'MobileRevGetCategoryID'union all

select 83,'MobileRevGetCategoryMaster'union all

select 84,'MobileRevGetCategoryRec'union all

select 85,'MobileRevGetDataCount'union all

select 86,'MobileRevGetMaJobmana'union all

select 87,'MobileRevGetMaJudgemana'union all

select 88,'MobileRevGetSystemMaster'union all

select 89,'MobileRevGetSystemSvrlist'union all

select 90,'MobileRevGetWk'union all

select 91,'MobileRevGetWkJobData'union all

select 92,'MobileRevGetXMLJobData'union all

select 93,'MobileRevJudgeBeriCheck'union all

select 94,'MobileRevJudgeUpdateTable'union all

select 95,'MobileRevMakeWk'union all

select 96,'MobileRevSetWk'union all

select 97,'MobileRevSetWkJobID'union all

select 98,'MobileRevSetWkMoJobmana'union all

select 99,'MobileRevUpdateTable'union all

select 100,'MobileSystemCtrlAdd'union all

select 101,'OpeResultGetAllHour'union all

select 102,'OpeResultGetAllHourRec'union all

select 103,'OpeResultGetAllToalJob'union all

select 104,'OpeResultGetAllWeek'union all

select 105,'OpeResultGetAllWeekRec'union all

select 106,'OpeResultGetAnsAvg'union all

select 107,'OpeResultGetAVGRec'union all

select 108,'OpeResultGetCategoryJob'union all

select 109,'OpeResultGetCategoryJobCount'union all

select 110,'OpeResultGetJobStatus'union all

select 111,'OpeResultGetMonthMoney'union all

select 112,'OpeResultGetMonthMoneyTbl'union all

select 113,'OpeResultGetPersonalABJob'union all

select 114,'OpeResultGetPersonalCJob'union all

select 115,'OpeResultGetPersonalDJob'union all

select 116,'OpeResultGetPersonalEJob'union all

select 117,'OpeResultGetPersonalHour'union all

select 118,'OpeResultGetPersonalJJob'union all

select 119,'OpeResultGetPersonalToalJob'union all

select 120,'OpeResultGetPersonalWeek'union all

select 121,'OpeResultGetTimeAvg'union all

select 122,'OpeResultGetTotalAvg'union all

select 123,'OpeResultGetTotalMoney'union all

select 124,'OpeResultWkTableClear'union all

select 125,'OpeResultWkTableClear2'union all

select 126,'SchedulingAddScheduling'union all

select 127,'SchedulingAddSchedulingExe'union all

select 128,'SchedulingAddSchedulingMasterList'union all

select 129,'SchedulingAddSchedulingMasterRec'union all

select 130,'SchedulingDelScheduling'union all

select 131,'SchedulingDelSchedulingExe'union all

select 132,'SchedulingDelSchedulingMaster'union all

select 133,'SchedulingDelSchedulingMasterList'union all

select 134,'SchedulingDelSchedulingMasterListPlMax'union all

select 135,'SchedulingEditSchedulingExe'union all

select 136,'SchedulingEditSchedulingMasterList'union all

select 137,'SchedulingEditSchedulingMasterRec'union all

select 138,'SchedulingGetComboData'union all

select 139,'SchedulingGetProgramName'union all

select 140,'SchedulingGetRunList'union all

select 141,'SchedulingGetSchedulCheck'union all

select 142,'SchedulingGetScheduling'union all

select 143,'SchedulingGetSchedulingExe'union all

select 144,'SchedulingGetSchedulingExeRec'union all

select 145,'SchedulingGetSchedulingMaster'union all

select 146,'SchedulingGetSchedulingMasterList'union all

select 147,'SchedulingGetSchedulingMasterListRec'union all

select 148,'SchedulingGetSchedulingMasterRec'union all

select 149,'SchedulingSetComboData'union all

select 150,'sp_MultiServer_GetJobList'union all

select 151,'sp_MultiServer_GetOPList'union all

select 152,'UserLoginCheck'union all

select 153,'UserUpdatePassWord'

declare @tablename varchar(100),@name varchar(100),

@count int,

@i int

set @i =1

create table #tableresult(procname varchar(200),tablename varchar(200))

while @i <154

begin

select @tablename = tablename from  #tempTablename

where id= @i

insert into #tableresult

select @tablename, name from sysobjects where id in(

SELECT distinct bb.depid as kk

FROM sysobjects 

JOIN sysdepends bb ON bb.id = sysobjects.id

where sysobjects.name=@tablename)

--print   @tablename + ' '+ @name

--print '---------'

--print @name

--print ''

set @i= @i +1

end

select * from #tableresult

--

--

--select tablename from  #tempTablename

--where tablename not in (select procname 

--from  #tableresult )

--order by tablename