MS-SQL 관련 프로시저 및 TABLE 보는 것들(아직 정리안된 것)

Posted by MD워시퍼
2011. 7. 23. 14:11 Study/MS-SQL
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