22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT a.name AS p_name,b.name AS p_type,a.length AS p_length,a.isoutparam AS p_isout
FROM syscolumns a, systypes b
WHERE a.xtype=b.xtype
AND b.name<>'sysname'
AND id = object_id('过程名','p')
SQLDMO.SQLServer oserver = new SQLDMO.SQLServer();
oserver.Connect("(local)", "sa", "sa");
SQLDMO._Database db = oserver.Databases.Item(2, "dbo");
SQLDMO.QueryResults result = db.StoredProcedures.Item(2, "dbo").EnumParameters();
string param = string.Empty;
for (int i = 1; i < result.Rows+1; i++)
{
param += result.GetColumnString(i, 1) + "<br>";
}
Response.Write(db.StoredProcedures.Item(2, "dbo").Name+"<br>");
Response.Write(param);
CREATE PROCEDURE p_a(@a char(1000) --传入参数,@b int output --返回参数 )
AS
select * from t_name
go