以存储过程 [dbo].[rpt_MktPromoter_V1] 为例子,查询的脚本如下:
select
[name],
type_desc,
create_date,
modify_date
FROM
sys.all_objects
where
name = 'rpt_MktPromoter_V1'
以存储过程 [dbo].[rpt_MktPromoter_V1] 为例子,查询的脚本如下:
select
[name],
type_desc,
create_date,
modify_date
FROM
sys.all_objects
where
name = 'rpt_MktPromoter_V1'