MS-SQL 관련 프로시저 및 TABLE 보는 것들(아직 정리안된 것)
728x90
select name , create_date, modify_date
from sys.objects
where type = 'P'
AND create_date > DATEAdd(dd, -70, GETDATE())
select * from INFORMATION_SCHEMA.PARAMETERS
sp_stored_procedures ST_LM_DMD_DEMAND_BREAKDOWN_FIXED_UPDATE
sp_help
sp_helptext
from sys.objects
where type = 'P'
AND create_date > DATEAdd(dd, -70, GETDATE())
select * from INFORMATION_SCHEMA.PARAMETERS
sp_stored_procedures ST_LM_DMD_DEMAND_BREAKDOWN_FIXED_UPDATE
sp_help
sp_helptext