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.Īpplies to: SQL Server 2008 (10.0.x) and later 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 and later versionsĮ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 and later versions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |