Easily extractss the complete stored procedure call hierarchy from "sysdepends" table of SQL Server and represent it in a pseudo-graphical tree-view.The script uses a temporary table (automatically created/dropped) to hold children and parents of relationships. For representing the call hierarchy the table contains a level field (depth) and a field containing the "enumerated path" (using […]
2005-03-14 (first published: 2005-03-01)
2,182 reads
Gets most important information of database structure. This includes all user tables, their fields, datatypes, defaults (including default constraint names), etc, primary keys and their fields, unique constraints and their fields, check constraints (including their conditions), foreign key constraints and their fields aswell as any other indexes and their fields. Should be quite useful for […]
2002-04-08
3,026 reads
By Devin-Knight
Welcome back to my Power Platform Quick Tips series! In this second episode we...
Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...
The wrap up post for T-SQL Tuesday #120. 9 bloggers contributed this month. The post...
Comments posted to this topic are about the item Numeric and Decimal, which is...
I have zero front end coding skills; last time I worked with any code...
Hello, i have a table called Codes and having below columns Declare table Codes(IdCode...
Ask SSC