我需要一个查询，它获取所有不允许存储过程中的空值的参数 [英] i Need a query which gets all the parameters which are not allowing nulls from a stored procedure

问题描述

我使用下面的查询，



但是它获取了允许空值和不允许空值的两个参数的数据。请帮助这个



SELECT

p.name AS参数

，t.name AS [类型]

FROM sys .procedures sp JOIN sys.parameters p

ON sp.object_id = p.object_id JOIN sys.types t

ON p.system_type_id = t.system_type_id

WHERE sp.name =yourStoredprocedurename

I Used below Query,

But it is getting data of Both parameters which are allowing nulls and Not allowing nulls .Please Help this

SELECT
p.name AS Parameter
,t.name AS [Type]
FROM sys.procedures sp JOIN sys.parameters p
ON sp.object_id= p.object_id JOIN sys.types t
ON p.system_type_id = t.system_type_id
WHERE sp.name ="yourStoredprocedurename"

推荐答案

这个 [ ^ ]应该可以帮到你。



[请鼓励通过投票解决方案或适合您的答案参与]

This[^] should help you.

[Please encourage participation by up-voting solutions or answers that work for you]

这篇关于我需要一个查询，它获取所有不允许存储过程中的空值的参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！