获取存储过程创建脚本的参数部分

[木易随风]

CREATE PROC P_TEST  
@pro VARCHAR(20),--注释  
@Pro2 VARCHAR(20)='',  
@ASNUm INT  
AS  
SELECT * from Table1 where pro=@pro And @pro2=@pro2 and ASNum=@ASNum 

有这样的一个存储过程，如何获取到As前边的那一段文字呢？
结果：

CREATE PROC P_TEST  
@pro VARCHAR(20),--注释  
@Pro2 VARCHAR(20)='',  
@ASNUm INT  
AS  

[發糞塗牆]

CREATE PROC P_TEST   
@pro VARCHAR(20),--注释   
@Pro2 VARCHAR(20)='',   
@ASNUm INT  
AS  
print @pro
print @pro2
print @asnum
SELECT * from Table1 where pro=@pro And @pro2=@pro2 and ASNum=@ASNum

[木易随风]

[-晴天]

create table #(id int identity(1,1),txt nvarchar(1000))
insert into #(txt)
exec sp_helptext 'P_TEST'
go
select * from # where id=2

[木易随风]

引用 3 楼 qianjin036a 的回复:

我想取到这样的一个字符串: CREATE PROC P_TEST @pro VARCHAR(20),--注释 @Pro2 VARCHAR(20)='', @ASNUm INT AS

[-晴天]

CREATE PROC P_TEST @pro VARCHAR(20),--注释 @Pro2 VARCHAR(20)='', @ASNUm INT AS begin select @pro,@pro2,@asnum end go declare @tb table(id int identity(1,1),txt nvarchar(1000)) declare @col nvarchar(1000) insert into @tb(txt) exec sp_helptext 'P_TEST' select @col=isnull(@col+' ','')+txt from @tb where id<=(select id from @tb where txt like 'AS%') select @col /* ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CREATE PROC P_TEST @pro VARCHAR(20),--注释 @Pro2 VARCHAR(20)='', @ASNUm INT AS (1 行受影响) */ go drop procedure p_test

[木易随风]

嗯 谢谢楼上的 我也试出来了.