SQL更改多存储过程参数

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)

原文地址:https://www.cnblogs.com/Ammy/p/1187926.html