SQL更改多存储过程参数

Posted on 2008-05-08 10:27 AmyQiu 阅读(349) 评论(0) 编辑收藏举报

CREATE PROCEDURE test
@uname varchar(10)
AS
BEGIN
END

declare @text nvarchar(4000)
select @text=replace(text,'@uname varchar(10)', '@uname varchar(20)')
from syscomments where id=object_id('test')
drop proc test
exec (@text)