SQL SERVER中调用存储过程时可以用 参数名=参数值 的方式传参数

官方文档上写着:

[ [ EXEC [ UTE ] ]

    {

        [ @return_status = ]

            { procedure_name [ ;number ] | @procedure_name_var

    }

    [ <b>[ @parameter = ]</b> { value | @variable [ OUTPUT ] | [ DEFAULT ] ]

        [ ,…n ]

[ WITH RECOMPILE ]

Leave a Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.