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,一定要重启哦,否则不生效。