(1)用 sql-dmo获得 存储过程参数: 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); (2)用SQL语从表里取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 = (select id from sysobjects where name = '存储过程的名字') (3)得用SQL语句生成某个库下所有存储过程脚本,并每个存为一个文件http://blog.csdn.net/fcuandy/archive/2007/12/12/1932179.aspx
可以通过sp_help 存储过程名 查看
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);
(2)用SQL语从表里取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 = (select id from sysobjects where name = '存储过程的名字')
(3)得用SQL语句生成某个库下所有存储过程脚本,并每个存为一个文件http://blog.csdn.net/fcuandy/archive/2007/12/12/1932179.aspx