2013-12-19 (first published: 2007-08-27)
20,728 reads
Deepthi Viswanathan Nair
2008-09-09
1,068 reads
Get list of tables used in a stored procedure
It used to find the table dependencies, helps the developers during an enhancement stage to find the tables are used in a stored procedure.
2007-08-30 (first published: 2007-03-16)
3,258 reads
Generate Stored Procedure/Functions Script with SP
It will help to generate DBscript of Stored Procedure/User defined Functions in SQL server without selecting those thru Enterprise manager.Pass the name of Stored procedures/Functions as parameters to the sp_Generate_Script, it generates the scripts and displayed on screen. Choose text format for result display.
2007-03-23 (first published: 2007-03-14)
2,144 reads
List of stored procedures which refer a DB table
It used to find stored procedures where a DB has been used.
2007-03-22 (first published: 2007-03-16)
457 reads
Blogs
SQL Data Type Conversions: Your Key to Clean Data & Sharp Queries
If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't...
T-SQL Tuesday #186–Agent Jobs
By Steve Jones
It’s that time of the month again, when the T-SQL Tuesday blog party takes...
T-SQL Tuesday #186 - Agent Job History Visualization
By alevyinroc
I’m hosting T-SQL Tuesday this month and our topic is Managing SQL Agent Jobs....
Forums
Execution Plan Operators
Comments posted to this topic are about the item Execution Plan Operators
Merge spans with Dates Logic
--for a given member if the startdate and endate is continous we need to...
Need help with merging data based on date and process
I have two sources , one coming from datalake and another is file. we...
Question of the Day
Execution Plan Operators
When looking at an execution plan in SSMS, what types of operators are shown?
See possible answers