![]() Is the parameter for module_name, as defined in the module. This can be a variable that holds the name of a natively compiled, scalar user-defined parameter Is the name of a locally defined variable that represents a module name. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.įor more information about procedure groups, see CREATE PROCEDURE module_name_var This feature will be removed in a future version of Microsoft SQL Server. This parameter is not used for extended stored procedures. Is an optional integer that is used to group procedures of the same name. If a server name is specified but no database name is specified, the SQL Server Database Engine looks for the module in the default database of the user. A module can be executed on another server running SQL Server if the user running the module has the appropriate permission to use that server (remote access) and to execute the module in that database. ![]() The names of extended stored procedures are always case-sensitive, regardless of the collation of the server.Ī module that has been created in another database can be executed if the user running the module owns the module or has the appropriate permission to execute it in that database. Module names must comply with the rules for identifiers. ![]() Is the fully qualified or nonfully qualified name of the stored procedure or scalar-valued user-defined function to call. When used to invoke a scalar-valued user-defined function, the return_status variable can be of any scalar data type. This variable must be declared in the batch, stored procedure, or function before it is used in an EXECUTE statement. Is an optional integer variable that stores the return status of a module. To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation. Syntax for SQL Server 2019Įxecute a pass-through command against a linked server Alternatively, see syntax in SQL Server 2017 and earlier instead. The following code block shows the syntax in SQL Server 2019.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |