set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
goCREATE PROCEDURE [dbo].[csp_System_GetProcedureParamters]
@procName varchar(260)AS
BEGIN
SET NOCOUNT ON; select syscolumns.name as ParameterName,
systypes.name as ParameterType,
syscolumns.length as ParameterLength,
syscolumns.xscale as ParameterDecimalDigits,
syscolumns.isoutparam as IsOutputParameter
from syscolumns,systypes
where systypes.name<>'sysname'
and syscolumns.id=object_id(@procName)
and systypes.xtype=syscolumns.xtype ORDER BY syscolumns.colidEND
set QUOTED_IDENTIFIER ON
goCREATE PROCEDURE [dbo].[csp_System_GetProcedureParamters]
@procName varchar(260)AS
BEGIN
SET NOCOUNT ON; select syscolumns.name as ParameterName,
systypes.name as ParameterType,
syscolumns.length as ParameterLength,
syscolumns.xscale as ParameterDecimalDigits,
syscolumns.isoutparam as IsOutputParameter
from syscolumns,systypes
where systypes.name<>'sysname'
and syscolumns.id=object_id(@procName)
and systypes.xtype=syscolumns.xtype ORDER BY syscolumns.colidEND
解决方案 »
- 求SQL语句将多条数据组织成一条数据
- 如何在查询范围内去除某条件
- SQL2000报错,但不知道是什么错,只有状态代码和错误代码,请大侠帮助,急!!!
- 我想把一个自增型的字段加上primary key,SQL怎么写?
- 很简单的问题,请大家帮忙!
- SQL SERVER安装问题!!
- 存储过程接受另一存储过程的查询结果
- 关于SQL server7.0和sql SERVer2000装在同一台机器上的问题,知道的,请帮忙
- ====如何在存储过程中获取某个查询SQL语句包括那些列(紧急求救)====
- Eclipse Design 翻译下
- 求一个SQL语句!
- 同一个学号同一门课程想取一个高分并设置有效字段值为是,请前辈指导一下,小弟先感谢了!
syscolumns.name as ParameterName, --字段名
systypes.name as ParameterType, --字段類型
syscolumns.length as ParameterLength, --字段長度
syscolumns.xscale as ParameterDecimalDigits, --沒有深究
syscolumns.isoutparam as IsOutputParameter --指示过程参数是否为输出参数
from syscolumns,systypes
where systypes.name <>'sysname'
and syscolumns.id=object_id('tb')
and systypes.xtype=syscolumns.xtype ORDER BY syscolumns.colid