sql stored procedures
Stored Procedure Wizard 1.2
Stored Procedure Tool for SQL Server. Create Stored Procedures for your database more>>
Build your own Stored Procedure and templates. Templates use Errorhandling, Debuginfo and comment options. Live update possible for getting latest templates. The tool is freeware and still under developement. Any ideas, suggestions or comments are welcome.
Stored Procedure Tool for SQL Server. Create Stored Procedures ...Stored Procedure Tool for SQL Server. Create Stored Procedures forLicense:Freeware
PostgrSQL Stored Procedure Generator 0.2
PostgrSQL Stored Procedure Generator is an application written in PgSQLto generate stored procedures around tables. more>> <<less
Stored Procedure Class Wizard 1.0
Stored Procedure Class Wizard (SPCW) is a development tool that lets you generate class files (.cpp and .h) more>>
Note that running SPCW against MS SQL Server or Sybase SQL Server
production databases is NOT recommended.
Following are the steps for generating class files:
Step 1:
=======
Choose from the menu.
Step 2:
=======
Select the procedure name for which you want to generate class files.
Microsoft SQL Server and Sybase SQL Server specific:
For procedures that return result set columns, choose
from the menu before generating the class files.
Step 3:
=======
Choose from the menu to generate .cpp and .h
recordset files.
Whenever you add/modify a procedure, choose from the
menu and then repeat step 3 (steps 2 & 3 in the case of MS SQL Server
and Sybase SQL Server).
To connect to another data source, first disconnect the current connection
and then connect.
Add the following lines to StdAfx.h:
#include // MFC database classes
#define ODBC_DSN_INFO _T("ODBC;DSN= ")
SQL Load Test 1.0
Generates a Visual Studio 2005 Unit Test from a SQL Server Profiler trace more>> Generates a Visual Studio 2005 Unit Test from a SQL Server Profiler trace
The SQL Load Test was designed to generate a Visual Studio 2005 Unit Test from a SQL Server Profiler trace. The tool extracts all the SQL statements and stored procedure calls from the trace and turns them into a single Visual Studio Unit Test, which can then be configured as a Visual Studio Load Test.
The tool does not interact with the database itself when it generates the test code and so it can be used "offline".
The generated code needs to be customised to include a connection string to the database under test. The generated code also includes hooks to allow the user to customise the parameters that are passed to the SQL statements and stored procedures, so that variability can be introduced into the data to prevent caching from giving artificially high performance figures.
The tool is intended to be used in conjunction with a client program that exercises the database. A trace of the clients SQL Server activity is captured using the SQL Server Profiler. This represents a test scenario, which is then processed by the tool to produce a Unit Test that replays the scenario.
The tool requires a trace to be collected using the SQL Server Profiler tool. The tool assumes that the trace only contains records pertaining to a single client session. So it is important to ensure that the trace is set up to only collect trace records generated by the activity of the client being used to generate the scenario.
It is therefore advisable to run the client on a machine from which no other activity on the SQL Server database is being generated, and to set the SQL Server Profiler filter accordingly.
System requirements:
- SQL Server 2005 SDK and the SQL Server 2005 Management Tools are installed.
Version restrictions:
- Only supports code that operates against a single database with a single connection.
- Prepared statements are not supported.
- The tool cannot (yet) configure and capture the trace for you, it requires you to use the SQL Profiler yourself to get a trace. With SQL 2005 it is possible to automate this.
- Not (yet) integrated into Visual Studio or the DB Pro edition.
- The tool has only been tested in an English environment, it is unlikely to work correctly in other environments, particularly with dates. In a future version this could be resolved by requiring the ExistingConnection event class, which lists language and date format.
- The tool does not support the XML data types.
- InputOutput parameters that are initialised with a NULL cannot be distinguished from Output-only parameters, so they are treated as Output only.
- When the trace passes a NULL to a binary parameter (e.g. image, binary, varbinary) the generated code will generate a runtime error. The generated code needs to be modified to pass SqlBinary.Null. The custom code generation extensibility point can be used to work around this.
- Positional parameters passed to SQL statements (as opposed to stored procedure calls) are not supported.
SQL to Sourcesafe Scripter 2.0.0
SQL to Sourcesafe Scripter is a 32 bit Windows application designed as a tool that automatically generates SQL schema scripts more>>
Microsoft SQL Server 2000 Patch: Extended Stored Procedures Vulnerability Update
Microsoft SQL Server 2000 Patch: Extended Stored Procedures Vulnerability Update offers you a patch designed to eliminate a security vulnerability in Microsoft® SQL Server® 7.0 and Microsoft SQL Server 2000. more>> <<less
Microsoft SQL Server 7.0 Patch: Extended Stored Procedures Vulnerability Update
Microsoft SQL Server 7.0 Patch: Extended Stored Procedures Vulnerability Update is designed to be a patch which eliminates a security vulnerability in Microsoft® SQL Server® 7.0 and Microsoft SQL Server 2000. more>> <<less
SQL Server Compare 2.2
SQL Server Compare is an easy-to-use tool to compare 2 SQL Server database schemas more>>
SQL Server Compare does not change the database in any way, and it can not execute any SQL statements - it only compares the schema. Requires SQL server or client installed.
Compares tables, stored procedures, indexes, triggers, users, views and record counts. SQL ... Compares tables, stored procedures, indexes, triggers, users, views and record counts. YouSQL Runner 1.0
SQL Runner is a small utility that lets you store and run SQL scripts against MySQL servers. It lets you build Script Sets that contain as many SQL scripts as you want. Each script can also contain tests to check if the fix is needed. more>> SQL Runner is a small yet powerful utility that lets you store and run SQL scripts against MySQL servers. With its multi-functions and high quality, this program lets you build Script Sets that contain as many SQL scripts as you want. Each script consists of a test (for determining if the fix is required), a fix (for updating the SQL data), and notes that you can use to store any additional information about the script. Script Sets are stored as XML files, and thus are quite easy to back up, share, and store in version controlled folders.
Major Features:
- Support for MySQL servers -- tested against MySQL 4.x and 5.x servers.
- Can store and manage multiple server connections
- Can store and manage multiple Script Sets
- Each Script Set can contain multiple Scripts
- Run scripts and tests individually or in batch modes
- Run on Windows and Linux (possibly Mac OSX too, but not tested)
Requirements:
- .NET Framework 2.0 (or Mono equivalent)
- MySQL server to connect to
WareSeeker Editor
SQL2SS Scripter 2.0.2
SQL2SS Scripter offers you a professional and highly-efficient 32 bit Windows application designed to automatically generate SQL schema scripts for Microsoft SQL Server databases, and store them in file system or under Microsoft SourceSafe version control. more>> <<less
FastQuery for SQL Server 2.0
Are you tired of using Enterprise Manager to connect to remote SQL Server databases, and finding it is unbearably slow? Look no further!! more>>
With great features, such as:
* Automatic source code generation to execute procedures.
* Advanced visual Query Builder for more complex SQL statements.
* Easy-to-use Stored Procedure wizard, including CURSOR statements.
* Create and manage table triggers.
* One-click backup and restore databases.
* Export tables to XML / Excel files.
* Perform text searches on stored procedures.
These are just a small number of features in FastQuery. To see how this product can help speed up your development time, download a demo version and try it out for youself.
Requirements: .NET Framework 1.1, MSDE/SQL Server 2000, MDAC 2.7
Whats new in this version: N/A
<<lessSQL Server Enterprise Mangler 1.0b
SQL Server Enterprise Mangler provides an easy way to manage objects contained in remote instances of MS SQL Server 2000 using a light, Web-based interface. more>>
SQL Server Enterprise Mangler 1.0b provides an easy way to manage objects contained in remote instances of MS SQL Server 2000 using a light, Web-based interface. This small application supports the creation, modification, and deletion of tables, stored procedures, and views as well as the running of adhoc queries. SQL Enterprise Mangler was developed using pure ASP 3.0 to provide complete portability and backward compatibility.
Microsoft SQL Server 7.0 Patch: Extended Stored Pr
This patch eliminates a security vulnerability in Microsoft? SQL Server? 7.0 and Microsoft SQL Server 2000 more>> This patch eliminates a security vulnerability in Microsoft? SQL Server? 7.0 and Microsoft SQL Server 2000. The flaw in SQL Server might allow a memory buffer allocated on the stack to be overwritten with arbitrary data, potentially allowing an attacker to execute arbitrary code in the SQL Server process space. This arbitrary code might be used for purposes as simple as shutting down the server to as complex as spawning a different process that might be used to take control of the server.
For More Information: Security Bulletin
<<less
SQL Object Scripter 1.2
SQL Object Scripter is one of the most advantageous tools which will write an XML File with attributes from your SQL Server 2005 database. more>>
SQL Object Scripter 1.2 is one of the most advantageous tools which will write an XML File with attributes from your SQL Server 2005 database. This XML file can be imported into this program to sync the objects in another database. The program will allow you to add columns or change column default values in a development environment, export an xml file and push the changes to a database in production without the loss of data.
It will also script views, Stored Procedures, and Functions. It uses the SQL Server 2005 Dependency detection to sort the tables and views in order for creation. This tool also allows you to pick and choose which objects to export as well as which objects to synchronize from the XML file.
Enhancements:
- Version 1.2 adds features that show how many objects are selected at a given time.
- Also now it is possible to sort everything alphabetically while still scripting and synchronizing in order of dependency.
- This makes objects easier to find while still allowing them to be created in the correct order.
SQL Object Scripter - Synchronize your database objects. SQL Object Scripter 1.0 - BridgeWood ... , Stored Procedures, and Functions. It uses the SQL Server 2005 Dependency detection to sortSQL Studio Query eXecutor 1.1.609.9686
SQL Studio Query eXecutor (QX) is a simple query and SQL script execution utility for Microsoft SQL Server more>>
There has been always a need for it when working with MSDE and SQL Server Express Edition or remote databases. It is not a replacement for the powerful Query Analyzer or the tools provided with Microsoft SQL Server, but rather an alternative for users that do not have those tools or do not want to install them.
Features color syntax highlighting, whole script or selected statements execution, executing of SQL scripts or stored procedures, and multiple result tables. Convenient functions to save SQL code to file and open existing script files. Provides execution results, table format output, and XML output.
SQL Studio QX has an advanced database server detection process to list all available servers. Supported are all editions of Microsoft SQL Server 2000 and 2005, including MSDE and SQL Server 2005 Express. It executes queries to remote servers.
Supported Databases:
- Microsoft SQL Server 2005 (all editions)
- Microsoft SQL Server 2005 Express
- Microsoft SQL Server 2000 (all editions)
- Microsoft MSDE 2000
- Remote Microsoft SQL Server instances
Main features:
- Write and execute queries and stored procedures
- Save SQL scripts for future use
- Open saved scripts and execute
- Multiple result tables
- XML output
- Color coding for SQL language syntax
a useful query and SQL script execution utility which is designed for Microsoft SQL Server. SQL ... or stored procedures, and multiple result tables. Convenient functions to save SQL code toLicense:none available
SQL Studio Query eXecutor (QX) is a simple query and SQL script execution utility for Microsoft ... or stored procedures, and multiple result tables. Convenient functions to save SQL code toLicense:Freeware
