Software Listing: Debugging Stored Procedures

Clean up the stored procedures in your SQL Server Database. The Unused Stored Procedures application performs an intelligent comparison of your source code and stored procedures to determine which stored procedures can be removed. It has advanced features such as handling of stored procedure dependencies, multi-line comment handling, and template based drop script generation. It also detects stored procedure usage in Nhibernate mapping files, and dataset XSDs. Try the demo today for free..

  • Platform: Win2000, Win7 x32, Win7 x64, Windows Server, WinOther, WinVista, WinVista x64

Debugging stored procedures over time, and following specific actions done by SQL code has always been tricky.

Even today, many database developers print out various message to screen in order to debug a procedure process and over time, on a system fully loaded with SQL code, those things become one big black-box.

The Log Table viewer project provides a unified logging interface for your SQL code a set of log-based procedures for your Server Side and a powerful log viewer/explorer for the client side.

Get Log Table Viewer and take it for a test drive to see just how useful it can actually be for you!

.

  • Platform: Win7 x64, Windows 7, WinOther, WinVista
  • SQLHelp
  • License: Shareware
  • Price: 75.00
  • Rating

SQLHelp produces programmers reference documentation for stored procedures. Requiring no active SQL Server connection, SQLHelp can produce annotated documentation describing each procedure, its parameters, output return values and result sets, executed procedures and the transactional nature of the procedure. Output options include searchable, colorized source code for each procedure..

  • Platform: WinOther

The tutorial shows you how to create stored procedures, after which you'll see how to use stored procedures in an ASP .NET web application..

  • Platform: Asp, Scripts

The SqlCommand class is designed to provide a simple, effective, and yet powerful way to use Microsoft SQL Server stored procedures through PHP, with the aid of the PEAR database abstraction layer. It provides an object-oriented method of declaring and configuring stored procedures in your PHP code, performs strong parameter "typing" of all values passed to the database, and allows you to easily retrieve return and output parameter values from your stored procedures..

  • Platform: PHP, Scripts
  • SQLWays
  • License: Shareware
  • Price: 3000
  • Rating

Ispirer\'s business is grounded on a cutting-edge migration tool SQLWays, which has the potential and powerful outcomes. It can take full control of the entire migration cycle providing high automation of all migration phases. SQLWays converts stored procedures, functions, triggers, database schema (DDL), data, views. The tool is especially useful when you need to transfer large data volumes over a short or limited period of time. Our IT professionals usually conduct comprehensive evaluation of our clients\' migration needs to learn how they can tune SQLWays to run the project fundamentally and promptly.

  • Platform: Linux, MS-DOS, Unix, Win2000, Win7 x32, Win7 x64, Windows Server, Windows Vista, WinOther, WinVista, WinVista x64

Don't you wish that there is a tool out there that will magically generate the Insert, Select, Update, and Delete stored procedure scripts for you by simply right-clicking on a database or table? Look no further! EZStoredProc (pronounced as "Easy Stored Proc") is that magical tool. Unlike the clumsy wizard provided by MS SQL Server Enterprise Manager, EZStoredProc does not add a number to the end of every parameter of the generated stored procedure. It is a lot smarter in handling primary key, composite keys, and identity column. It does not generate a stored procedure that passes in duplicate parameters when you have both primary key and identity field as the same column.

  • Publisher: Ivertech
  • Date: 26-06-2012
  • Size: 480 KB
  • Platform: WinOther

The MyDbUtils application was designed to be a small tool that can extract Stored Procedures, Functions and Views from a MSSQL database.

MyDbUtils will also allow users to generate script files containing the delete and create statements.



.

  • Platform: WinOther

T4S Stored Procedure Generator reads database schema and generates stored procedures based on your selection and configuration. It supports MS SQL Server 2000, 2005, 2008, MSDE, SQLExpress databases. It is entirely built in C# and .NET 2.0.

Key features of T4S Stored Procedure Generator are, joined stored procedures based on foreign key columns, join type selection based on nullability of column or as per user requirement, error handling (try catch based for 2005 & 2008 database, @@error function for 2000 database), transaction management (commit - rollback), concurrency validation, options to return primary keys several ways, paged stored procedure with and without CTE, default value assignment at the time of parameter passing, Flexible SP naming convention, hierarchical SP using Common Table Expression for self reference...

  • Platform: Windows Server, WinOther, WinVista

Alt SQL Developer is an integrated development environment for Oracle database objects and provides convenient opportunities for creating, editing, testing, debugging, and optimizing SQL queries, stored procedures in PL/SQL, including packages, functions, triggers, user-defined datatypes, etc. Alt SQL Developer focused on simplicity, accessibility and ease of development of database objects, which in turn gives the programmer an ability to increase productivity of the application development for Oracle platform. Powerful PL/SQL Editor, Syntax Highlighting, Code Folding, Code Templates, using the technology of automatic encoding tooltips, Intelligent Recommendations, Macro Library and many other important features that makes programming easier and improves its quality; Integrated Debugger; SQL window allows you to enter any SQL...

  • Platform: Win2000, Win7 x32, Win7 x64, Windows Server, Windows Vista, WinOther, WinVista, WinVista x64

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

These stored procedures support pre and post commands, as well as up to three commands to be executed for each iteration (either databases or tables).
.

  • Platform: WinOther

SQL Script Recovery is a decrypt software for SQL Server 7 and 2000 with examining stored procedures, triggers, views and user-defined functions.If you encrypt your own source code of stored procedures, triggers, views or user-defined functions with "with encryption" option,but you neglectful lost it,the application can help you recover it ..

  • Publisher: HongJun Guo
  • Date: 12-12-2003
  • Size: 1923 KB
  • Platform: Win2000, WinOther

Orbital's SQL Decryptor is the first product to decrypt SQL triggers, views, user defined functions and stored procedures in an easy to use Enterprise Manager-like graphical interface. It works quickly to decrypt items in Microsoft® SQL Server 6.5, 7.0, 2000 and MSDE. Orbital's SQL Decryptor allows for easy viewing of decrypted code with T-SQL syntax highlighting and multiple format exportation. Features Include: Works with Microsoft® SQL Server 6.5, 7.0, 2000 and all versions of the Microsoft® Database Engine (MSDE). No more loading up multiple programs and having to manipulate different scripts for each server.

  • Platform: Win2000, Windows Server, WinOther

ADO.NET Express is an add-in for Visual Studio 2003 that generates class methods for calling stored procedures and executing common types of SQL statements. It supports C#/VB and SQL Server/Oracle. ADO.NET Express looks similar to Server Explorer. You can add database connections and browse schema objects such as tables and stored procedures. You can right click on a schema object to generate ADO.NET code for this object. For example, you can right-click on a stored procedure and generate a C# method that executes the stored procedure and returns a DataReader. ADO.NET Express is especially useful for ASP.

  • Platform: Win2000, Windows Server, WinOther

SwisSQL - Oracle to DB2 Edition is an automated migration tool to convert stored procedures implemented in Oracle PL/ SQL code into equivalent IBM DB2 SQL. It automates more than 80% of the Oracle PL/SQL code conversion into IBM DB2 with very minimal manual intervention. SwisSQL migration tool removes the time consuming, tedious and error prone manual effort involved in typical migration projects and provides great productivity benefit with high quality output and short turnaround time. Features * Migration of Oracle PL/ SQL procedures, functions, triggers, cursors, tables and views into TransactSQL * Support for conversion of PL/ SQL In-Built Functions, Datatypes, and SQL Queries * Support for conversion of all Transaction features.

  • Publisher: AdventNet
  • Date: 04-02-2005
  • Size: 19456 KB
  • Platform: Win2000, WinOther

SwisSQL - Oracle to Sybase Edition is an automated migration tool to convert stored procedures implemented in Oracle PL/ SQL into equivalent Sybase Adaptive Server Transact SQL code. It automates more than 80% of the PL/ SQL code conversion into TransactSQL with very minimal manual intervention. SwisSQL migration tool removes the time consuming, tedious and error prone manual effort involved in typical migration projects and provides great productivity benefit with high quality output and short turnaround time. Features * Migration of Oracle PL/ SQL procedures, functions, triggers, cursors, tables and views into TransactSQL * Support for conversion of PL/ SQL In-Built Functions, Datatypes, and SQL Queries * Support for conversion of all Transaction features.

  • Publisher: AdventNet
  • Date: 11-02-2005
  • Size: 10240 KB
  • Platform: Win2000, WinOther

SwisSQL - Sybase to Oracle Edition is an automated migration tool to convert stored procedures implemented in Sybase ASE (Adaptive Server Enterprise) Transact SQL into equivalent PL/ SQL code. It automates more than 80% of the Sybase Transact SQL code conversion into Oracle PL/SQL with very minimal manual intervention. SwisSQL migration tool removes the time consuming, tedious and error prone manual effort involved in typical migration projects and provides great productivity benefit with high quality output and short turnaround time. Features * Migration of Transact SQL procedures, functions, triggers, cursors, tables and views into Oracle PL/SQL.

  • Publisher: AdventNet
  • Date: 19-03-2005
  • Size: 18432 KB
  • Platform: Win2000, WinOther

Defining and managing the database-structure, importing data, editing data is now simple with this nice and convenient program. For designers with only a basic grasp of databases, this program is the way to go to make you independent of SQL gurus. What makes EngInSite MySQL Client a cut above the rest? Just look at the following features: ï‚§ Very fast retrieval of data ï‚§ Manage foreign key relationships. ï‚§ Fully InnoDB compliant ï‚§ Connection and MySQL service manager ï‚§ Syntax-highlighting and Intellisense ï‚§ Save your commonly used SQL scripts in a personal folder with a click of mouse ï‚§ View advanced table properties, such as Type, Charset, Comment, Key_Length.

  • Publisher: Luckasoft
  • Date: 20-05-2005
  • Size: 2498 KB
  • Platform: Win2000, Windows Server, WinOther

Generates ready to use SELECT, INSERT, UPDATE, DELETE and VIEW SQL Statements and SQL Stored Procedures from table structures of MS SQL Server 2000 and 2005. Supports Optimistic Concurrency Control for Update, Foreign-Keys, etc. Connects Local as well as Remote Server..

  • Publisher: Datacraft
  • Date: 13-05-2006
  • Size: 356 KB
  • Platform: Win2000, Windows Server, WinOther

SwisSQL - SQL Server to Oracle Edition is an Automated Migration tool to convert stored procedures implemented in Microsoft SQL Server Transact SQL into equivalent Oracle PL/SQL code. It automates more than 80% of the Transact SQL code conversion into PL/SQL with very minimal manual intervention. SwisSQL migration tool removes the time consuming, tedious and error prone manual effort involved in typical migration projects and provides great productivity benefit with high quality output and short turnaround time. SwisSQL - SQL Server to Oracle Edition provides the following significant features: - Migration of SQL Server Transact SQL procedures, functions, triggers, cursors, tables and views into PL/SQL.

  • Publisher: AdventNet
  • Date: 12-06-2007
  • Size: 15128 KB
  • Platform: Win2000, WinOther

Page: 1 | 2 | 3 | 4 | 5 | Freeware

New Reviews


Graphs Made Easy

For some students, understanding statistics is a tough mountain to climb. However, this problem can be easily solved using pictorial representation of numbers and data, popularly known as Graphs. Since Graphs are easier to interpret, these are often ...


Advanced System Optimizer

Keeping your Computer fast, clean and error free is of utmost importance if you want to get most out of it. Over the passage of time, many personal computers get clogged with errors, unnecessary or duplicate files and shortcuts leading to fragmented ...


Angry Birds

Angry birds is one of the most successful games of all time, despite the fact that it has been free from the very beginning. Angry birds is a experimental physics game, with the objective being to fling all of your birds into the structures occupied ...


Skies of War

Skies of war is a top down plane shooter free ware game which really does reinvent the concept, and add a great deal to it. In skies of war you are a plane tasked with destroying a vast number of bases, enemy units and enemy planes. As you play ...


Arctic Quest Game

Arctic  quest game (referred to in game as simply arctic quest) is a free ware downloadable game by free ride games, a game development website with a variety of games also downloadable from this site. Arctic quest is a very interesting puzzle ...


Ocster 1-Click Backup

Nowadays, backing up is more of a necessity than ever before. Daily, people are experiencing hardware failures, computer crashes, and virus attacks that are damaging and destroying data, and in some cases just silly mistakes are causing people to ...


Castle Wars

Castle wars is a unique blend of the strategy genre with a small amount of war and micro management elements added in to make it more unique. In castle wars the aim is to eliminate all the other players from the map, and become the only player left ...


Wise Disk Cleaner

Everybody computer is full of temporary and unnecessary files! Even if you don’t know they are there, they are! Wise Disk Cleaner helps to rid your system of these useless files that are just sitting around taking up your disk space. ...


TopDesk

It feels better, when the main screen of the computer looks good. However, in most of the cases, you would find the main screen or desktop of the computer is filled with the ugly looking icons which spoil the beauty of your desktop, and there comes ...



New Downloads

RoboTask

RoboTask allows you to
automate any combination of
tasks on your computer,
ranging from simply launching
applications, to ...

PDF-XChange Standard

The junior member of our
highly praised PDF-XChange
range of software tools aimed
at users wishing to create the
smallest ...

ACDSee Ultimate

With GPU-accelerated
adjustment layers, RAW
editing, and an arsenal of
professional digital asset
management tools, ...

MailShelf Pro

MailShelf Pro is a
professional email archiving
solution that covers all
important aspects of a secure
and compliant ...

SRDx Photoshop Plugin Win

Photoshop Plugin for macOS
10.10 and later or Win7 and
later for time and work
efficient Dust and Scratch
Removal. ...

MotionCaster Pro For
Windows

MotionCaster is a live
streaming and broadcasting
software that can easily
handle complex tasks such as
Switching, ...

Audials Radiotracker

Radio Player and recorder of
100,000 Radios + records
targeted music from radios of
12,000,000 Songs of 3,000,000
Album ...

LemonWire

LemonWire is a powerful
download program developed for
rapid connections and
downloads that uses its own
built-in ...

PhoneRescue for SAMSUNG

PhoneRescue for SAMSUNG is an
ultimate data recovery
software designed for
recovering your lost messages,
contacts, call ...



Related Searches

Delphi Mysql Stored Procedures
Delphi Sql Stored Procedures
Delphi Stored Procedures Sample
Diagram Stored Procedures
Encrypt Sql Stored Procedures
Extended Stored Procedures
Extended Stored Procedures Delphi
Ms Access Stored Procedures
Ms Sql Edit Stored Procedures
Mysql Stored Procedures Base Convert
Mysql Stored Procedures Delete File
Oracle Compare Stored Procedures