sp_depends system stored procedure or query the says depends on system table to return a list of objects that a user-defined function depends upon
SELECT DISTINCT so1.name, so2.name FROM sysobjects so1
INNER JOIN sysdepends sd
ON so1.id = sd.id
INNER JOIN sysobjects so2
ON so2.id = sd.depid
WHERE so1.name = '<>'
Posted Date:- 2021-08-17 08:04:46
What is the role of GRANT and REVOKE commands?
In SQL, what is the best thing about the Views you have come across?
How do you sort records in a table?
Write a Query to display the date after 12 months?
Can we hide the definition of a stored procedure from a user?
Can we store Videos inside the SQL Server table?
Can we store PDF files inside the SQL Server table?
Why we use the OPEN XML clause?
How can we determine what objects a user-defined function depends upon?
In what sequence SQL statements are processed?
How will you create a column alias?
What is the difference between CHAR and VARCHAR2 datatype in SQL?
What do you mean by data manipulation language - DML?
Is it possible for the users to compare the test for the NULL values in SQL?
What is the difference between Union and Union All command?
What is the maximum number of tables that can join in a single query?
What Is Cascade delete/update?
What is the largest value that can be stored in a BYTE data field?
How to avoid duplicate records in a query?
What are the popular Database Management Systems in the IT Industry?
Tell something about the Temp Table?
Can You Explain Integration Between SQL Server 2005 And Visual Studio 2005?
What are user-defined data types and when you should go for them?
Name a few commands which you think are important in SQL for managing the database?
In SQL, what do you know about the composite primary key?
What are the multiple ways to execute a dynamic query?
What is the difference between LEFT JOIN with WHERE clause & LEFT JOIN with nowhere clause?
Can we add an identity column to the decimal datatype?
How do you generate file output from SQL?
1.Query to find Second Highest Salary of Employee?(click for explaination)
What is the difference between the WHERE and HAVING clauses?
What is the difference between the RANK() and DENSE_RANK() functions? Provide an example.
What is an execution plan? When would you use it? How would you view the execution plan?
How the Inner Join in SQL is different from that of Outer Join?