摘要:
获取某一存储过程的参数列表selecttb.nameastypename,ta.*fromsyscolumnsastainnerjoinsystypesastbonta.xtype=tb.xtypewhereta.idin(selectidFromsysobjectsasawhereOBJECTPROPERTY(id,N'IsProcedure')=1andid=OBJECT_ID(N'[dbo].[SP_POPULATECPIACCOUNTINBATCH]'))andtb.name<>'sysname'orderbyta.colid 阅读全文