『草稿』如何获取 SQL Server 存储过程的详细语法

SELECT m.[definition]
FROM [MyTemp].sys.sql_modules m
    INNER JOIN [MyTemp].sys.objects o
        ON m.object_id = o.object_id
WHERE o.schema_id = SCHEMA_ID(N'dbo')
    AND o.name = N'AspNet_SqlCacheRegisterTableStoredProcedure'

 

posted on 2013-03-27 18:02  InkFx  阅读(234)  评论(2编辑  收藏  举报