Transact-SQL 语法约定语法syntaxsql 复制 sp_depends [ @objname = ] N'objname' <objname> ::= { [ database_name. [ schema_name ] . | schema_name. ] object_name } [ ; ] 参数[ @objname = ] N'objname'@objname为 nvarchar(776),没有默认值。
set @sql='UseMe ''a'''--这里用到了另一个存储过程 exec(@sql)--动态调用 end --查看引用--结果 sp_depends UseOthers--Object does not reference any object, and no objects reference it. sp_depends UseMe--Object does not reference any object, and no objects reference it. --可见sp_depen...
Transact-SQL 语法约定语法syntaxsql 复制 sp_depends [ @objname = ] N'objname' <objname> ::= { [ database_name. [ schema_name ] . | schema_name. ] object_name } [ ; ] 参数[ @objname = ] N'objname'@objname为 nvarchar(776),没有默认值。
AU= Lock on an allocation unit. This information is incomplete in SQL Server. Resourcenchar(32)The value identifying the resource that is locked. The format of the value depends on the type of resource identified in theTypecolumn: TypeValue:ResourceValue ...
sp_depends determines the dependencies by looking at the sys.sql_dependencies catalog view.PermissionsRequires membership in the public role.ExamplesA. Listing dependencies on a tableThe following example lists the database objects that depend on the Sales.Customer table in the AdventureWorks database....
64Run when SQL Server Agent service starts 128Run when the computer is idle (not supported inAzure SQL Managed Instance) [@freq_interval= ]@freq_interval The days that a job is executed.@freq_intervalisint, with a default of1, and depends on the value of@freq_type. ...
64Run when the SQL Server Agent service starts. 128Run when the computer is idle. [@freq_interval= ]freq_interval Day that the job is executed.@freq_intervalisint, with a default of0, and depends on the value of@freq_typeas indicated in the following table: ...
64Run when SQL Server Agent service starts 128Run when the computer is idle (not supported inAzure SQL Managed Instance) [@freq_interval= ]@freq_interval The days that a job is executed.@freq_intervalisint, with a default of1, and depends on the value of@freq_type. ...
NULL Replication automatically sets @schema_option to a default value, the value of which depends on other article properties. The "Default Schema Options" table in the Remarks section shows the default schema options based on article type and replication type.The default for non-SQL Serv...
Specifies the name of the variable in the external script that contains the data to be returned to SQL Server upon completion of the stored procedure call. The data type of the variable in the external script depends on the language. For R, the output must be a data frame. For Python, ...