SELECT name, --参数名xtype,--数据类型length,--数据长度isoutparam,--参数类型：入参0/出参1isnullable--是否允许为nullFROM syscolumns where ID in (SELECT id FROM sysobjects as a WHERE OBJECTPROPERTY(id, N'IsProcedure') = 1 AND id = object_id(N'[dbo].[存储过程名]'))
本文共 295 字，大约阅读时间需要 1 分钟。
SELECT name, --参数名xtype,--数据类型length,--数据长度isoutparam,--参数类型：入参0/出参1isnullable--是否允许为nullFROM syscolumns where ID in (SELECT id FROM sysobjects as a WHERE OBJECTPROPERTY(id, N'IsProcedure') = 1 AND id = object_id(N'[dbo].[存储过程名]'))
转载于:https://www.cnblogs.com/mahatmasmile/p/10235540.html