Go to my github

SQL server 查看脚本

原文出处:http://blog.csdn.net/xiaochunyong/article/details/7455051

--Siuon
--查看存储过程源码
create procedure mp_helptext(
	@name varchar(255)
)
as
declare @object_id int,
				@sourcecode varchar(max),
				@line varchar(max),
				@end int,
				@rn varchar(2),
				@tab varchar(1)
				
declare @source table(
	source varchar(max)
)
 
set @rn = char(13)+char(10)
set @tab = char(9)
 
 
select @sourcecode = definition from sys.sql_modules where object_id=object_id(@name)
 
while(charindex(@rn,@sourcecode)!=0)
begin
	set @end=charindex(@rn,@sourcecode)
	set @line = replace(substring(@sourcecode,1,@end-1),@tab,@tab+@tab)
	if(charindex('create',@line)<>0 and (charindex('proc',@line)<>0 or charindex('view',@line)<>0 or charindex('function',@line)<>0 or charindex('trigger',@line)<>0))
	begin
		set @line = replace(@line,'create','alter')
	end
	insert into @source(source) values(@line)
	set @end = @end + 2
	set @sourcecode = substring(@sourcecode,@end,len(@sourcecode))
end
insert into @source(source) values(@sourcecode)
 
select * from @source

  

设置SQL Server 快捷键 绑定 该存储过程:

SQL Server菜单  工具--选项--环境--键盘:   在这里我是设置的Ctrl+F1键  对应刚刚的存储过程名。

点击确定后,重启SQL Server Manage Studio,一定要重启哦,否则不生效。

 

posted @ 2021-09-06 14:18  峡谷少爷  阅读(422)  评论(0编辑  收藏  举报