select
[name]
,create_date
,modify_date
FROM
sys.all_objects
where
-- type_desc = N'SW_SP_WeiXinUserInfo_GetUserInfoByOpenID'and
name = 'SW_SP_WeiXinUserInfo_GetUserInfoByOpenID' --存储过程名字
--and modify_date >='2013-03-05 00:00:00'
select
[name]
,create_date
,modify_date
FROM
sys.all_objects
where
-- type_desc = N'SW_SP_WeiXinUserInfo_GetUserInfoByOpenID'and
name = 'SW_SP_WeiXinUserInfo_GetUserInfoByOpenID' --存储过程名字
--and modify_date >='2013-03-05 00:00:00'