led交通灯,从零开始的异世界生活本子,孙耀庭
自定义函数,获取存储过程参数,可以先参考这篇《sql server information_schema》
set ansi_nulls on go set quoted_identifier on go -- ============================================= -- author: insus.net -- create date: 2019-05-14 -- update date: 2019-05-14 -- description: 获取存储过程参数 -- ============================================= create function [dbo].[tvf_storedprocedureparameter] ( @storedprocedurename sysname ) returns @parameters table ( [parameter name] sysname, [data type] sysname, [length] int, [scale] int, [direction] nvarchar(20) ) as begin insert into @parameters select parameter_name,data_type,isnull(character_maximum_length, numeric_precision),numeric_scale,parameter_mode from information_schema.parameters where specific_schema = 'dbo' and specific_name = @storedprocedurename order by ordinal_position return end go
实例说明:
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
SQL Server免费版的安装以及使用SQL Server Management Studio(SSMS)连接数据库的图文方法
SQL Server 2017 Developer的下载、安装、配置及SSMS的下载安装配置(图文教程详解)
网友评论