求助通过存储过程进行动态查询并返回值

[yuanpengwen]

我现在想通过一个存储过程完成传入一个表名然后返回这个表有多少列请问该如何写？（SQL server）

[NBDBA]

create proc pr_GetColumnNumber
@TableName nvarchar(128)
as
select count(1) as ColumnNumber
from syscolumns
where id = object_id(@tablename)
go

[快溜]

[Quote=引用 1 楼 nbdba 的回复:]
SQL code
create proc pr_GetColumnNumber
@TableName nvarchar(128)
as
select count(1) as ColumnNumber
from syscolumns
where id = object_id(@tablename)
go
[/Quote]+1不要发重复贴。