sp_CascadingDataViewer

  •        60

sp_CascadingDataViewer is a stored procedure enables the user to find all data that is dependant on a given set of rows in a given table in a given database. It traverses the database's foreign keys to find that dependant data. It is written in T-SQL and works on SQL Server 2008.

http://cascadingdataviewer.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

Stored Procedure Generator (for SQL Server 2000/2005)


This utility automatically creates all basic stored procedures (SelectAll, SelectRow, InsertRow, UpdateRow, DeleteRow) necessary to access the SQL Server Tables. It also has options to create Data Access Layers for those stored procedures.

FileSystemHelper SQL Server CLR


FileSystemHelper SQL Server CLR provides a collection of CLR stored procedures and functions for interacting with the file system. Using these stored procedures and functions will allow you to avoid enabling xp_cmdshell on your SQL Server instances.

crichey-ActiveDocument


ActiveDocument is an open source Ruby connector for MarkLogic server, although at a later date it could potentially expanded to work with other XML databases. The goal of ActiveDocument is to make it as easy for developers to work with MarkLogic as ActiveRecord makes it for them to work with an RDBMS. The intent is to make them write as little XQuery as possible. If they can get 80% of their tasks done without having to write any XQuery that should increase adoption. Performance is less of a con

Sql Server Permissions Auditor


Sql Server Permissions Auditor helps audit permissions on your Sql Server 2005 and up database. The software will audit permissions on tables, stored procedures, and look for several patterns of concern in stored procedures. It requires admin permissions to run. The first ...

SQL Database script generation for Visual Studio 2008


This project host a Visual Studio Add-In for creating schema scripts, stored procedures and views from SQL Server. Basically, with a couple of clicks you can generate all your tables, stored procedures, and views as individual scripts with DROP/Add statements for foreign keys...



SqlValidator - Check Validity of SQL Server Stored Procedures/Views/Functions/Triggers


Check Validity of SQL Server Stored Procedures/Views/Functions/Triggers

PHPMyAdmin


phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

SQL Server Web Tools


SQL Server Web Tools is a Web-based Administration tool to manage SQL Server databases. With SSWT, you can administer accounts, manage databases and tables, write and run queries and Stored Procedures, and much more.

Data Tier Generator


Microsoft .NET project that generates SQL Server 2000 scripts for stored procedures and C# classes used to access those stored procedures. The stored proecedures generated are as follows: Insert, Update, Delete, Select, SelectByPK, SelectByFK

Coolstorage - ORM library for .NET


The main strength of Vici CoolStorage is the ease of use. Most ORM tools still require a lot of unneeded code to accomplish basic data persistence tasks, but Vici CoolStorage is designed to relieve the programmer from these tedious and error-prone tasks, making it very intuitive to use.

SPUnit


SPUnit is an application of the popular xUnit framework concept to enable unit testing of SQL Server stored procedures. The project includes a set of framework stored procedures that provide similar fixture and assertion capabilitieis to the other xUnit f

ET-SQL - An ETL framework built entirely using T-SQL stored procedures


An ETL framework built entirely using T-SQL stored procedures

DB Compare


DB Compare is a simple utility that compares the schema (Tables, Views, and Stored Procedures) of two SQL Server databases.

SQL Write to File


Export stored procedures, functions, triggers, tables and table contents to text files. SQLWriteToFile makes it easier for developers and DBA's to export a SQL development project, for backup or installation. It is developed in C#. Earlier VB version available by request.

SQL Iterators - Making the life of the DBA that much easier


There are several undocumented stored procedures that many DBAs rely on to do their day to day work - namely sp_MSForEachDatabase and sp_MSForEachTable. This project is a SQL-CLR assembly that provides equivalent functionality to those two stored procedures.

SQL Script Runner


SQL Script Runner is a lightweight program that can be used to quickly run multiple SQL scripts against a database. If you have all of your Stored Procedures, UDFs, Tables, Changescripts, etc. stored in individual files (e.g. for source control) you can use this to quickly ru...

ApacheDS - Apache Directory Project


ApacheDS is an embeddable directory server entirely written in Java, which has been certified LDAPv3 compatible by the Open Group. Besides LDAP it supports Kerberos 5 and the Change Password Protocol. It has been designed to introduce triggers, stored procedures, queues and views to the world of LDAP which has lacked these rich constructs.

NHibernate - object-relational mapper for .NET


NHibernate is a mature, open source object-relational mapper for the .NET framework. NHibernate is a port of Hibernate Core for Java to the .NET Framework. It handles persisting plain .NET objects to and from an underlying relational database.

Count Widget


CountWidget is a series of C# projects built to demonstrate RAD Studio Code Generation Toolkit to create 100% stored procedure driven data tiers for SQL Server.