.Net获取指定存储过程的参数信息 

select * from syscolumns where ID in
 (SELECT id FROM sysobjects as a
  WHERE OBJECTPROPERTY(id, N'IsProcedure') = 1
  and id = object_id(N'[dbo].[proc_name]'))

 

posted @ 2019-03-08 15:23  Chanwah  阅读(149)  评论(0)  编辑  收藏  举报