获得存储过程,可以如下: select * from dbo.sysobjects where OBJECTPROPERTY(id, N'IsProcedure') = 1
字段类型,可以如下 select * from syscolumns where ID in ( SELECT id FROM sysobjects as a WHERE OBJECTPROPERTY(id, N'IsProcedure') = 1 and id = object_id(N'[dbo].[*****]') // “*****” is your stored procedure )
select * from dbo.sysobjects where OBJECTPROPERTY(id, N'IsProcedure') = 1
select * from syscolumns where ID in
(
SELECT id FROM sysobjects as a WHERE OBJECTPROPERTY(id, N'IsProcedure') = 1
and id = object_id(N'[dbo].[*****]') // “*****” is your stored procedure
)