09 2012 档案

获取数据库中存储过程的定义
摘要：获取某一存储过程的参数列表selecttb.nameastypename,ta.*fromsyscolumnsastainnerjoinsystypesastbonta.xtype=tb.xtypewhereta.idin(selectidFromsysobjectsasawhereOBJECTPROPERTY(id,N'IsProcedure')=1andid=OBJECT_ID(N'[dbo].[SP_POPULATECPIACCOUNTINBATCH]'))andtb.name<>'sysname'orderbyta.colid 阅读全文
posted @ 2012-09-13 14:13 Darren.Xiang 阅读(287) 评论(0) 推荐(0)