同志们我需要帮忙，谢谢了！！！

[renminyinhang]

set @length=0--为int型
set @length=(select length from syscolumns where id=object_id(@p) and name=@n)
@n,@p为存储过程的参数@p='dt_checkinobject_u',@n='@chObjectType'
我在存储过程里用时出错


如果将他写成
set @length=(select length from syscolumns where id=object_id('dt_checkinobject_u') and name='@chObjectType')
就不在出错了
怎么修改上面的语句让他的@length的值显示的和下面的@length值相同呢

[pengdali]

set @length=0--为int型
select @length=length from syscolumns where id=object_id(@p) and name=@n

[伍子V5]

declare @length int,
@sqls nvarchar(4000)
set @sqls='select @a=length from syscolumns where id=object_id('''+@p+''') and name='''+@n+''''

exec sp_executesql @sqls,N'@a int output',@length output
select @num

[renminyinhang]

我试了不好使的

[txlicenhe]

declare @length int,@p varchar(10),@n varchar(10)
set @length=0--为int型
set @p = 'sysobjects'
set @n = 'name'
select @length=length from syscolumns where id=object_id(@p) and name=@n
select @length

-----------
256

（所影响的行数为 1 行）