 |
MS SQL Server 7.0/2000 Extended Stored Procedure class for Visual C++ 6, 7.
Write Extended Stored Procedures for Microsoft SQL Server with ease:
* Control over input/output procedure parameters.
* Return an arbitrary number of recordsets.
* Parameters and Fields can be accessed by using methods such as SetInt(), GetDateTime(), SetMoney(), etc.
ms sql mssql extended stored procedure ods api open data services visual c dll write extended stored procedures
|
 |
MS SQL Server 7.0/2000 Extended Stored Procedure component for Delphi 5,6,7.
Write Extended Stored Procedures for Microsoft SQL Server with ease:
* Control over input/output procedure parameters.
* Return an arbitrary number of recordsets.
* Parameters and Fields can be accessed by using the familiar properties: AsInteger, AsDateTime, AsCurrency, etc.
* Real world code: it works as a part of the complex accounting system, 7 days a week, 24 hours a day.
ms sql mssql extended stored procedure ods api open data services delphi dll write extended stored procedures
|
 |
File Utility extended stored procedures adds to T-SQL capabilities of:
* Work with files and directories;
* Read and write files line-by-line or by arbitrary data blocks;
* Export and import BLOB data from the disk files to the table fields of TEXT/NTEXT/IMAGE datatype;
* Work with INI files;
* Format string templates.
write file read file file utils mssql sql server extended stored procedure ods open data services delphi xp xproc
|
 |
If you often use stored procedures, you certainly know how tiresome it is to write one and the same code defining the name, the type and the size of every parameter every time you want to call the command object. And if you happened to change the interface of the stored procedure, you most likely had to return to your data access layer and correspondingly modify the calling of the stored procedure. Programmers are ready to do anything to simplify the process: to centralize the calling of stored procedures at the data access layer, to write wrappers round them, and even implement automatic generators.
The Stored Procedure Proxy Generator program is designed for the radical simplifying of this problem solution. Based on the information taken from the specified database it builds .NET-assembly with a set of methods representing proxies for all (or the chosen) stored procedures of the database. After that the calling of the stored database is an elementary call of the built proxy method.
dotnet net framework stored procedure proxy generator sql server database visual
|
 |
GiPo@DB_Utilities is a set of utilities for Windows 95/98/ME/NT/2000/XP that provide an easy way to work with different OLE DB- and ODBC-compatible databases and data sources such as Microsoft SQL Server 7.0/2000, Oracle DBMS, Informix, MySQL, DB2, Microsoft Access, dBase, Paradox, FoxPro, Visual FoxPro and many other databases that have OLE DB providers.
Main Features:
Provides the visual browsing and editing for OLEDB- and ODBC-compatible databases.
Supports the connection to a DB using Microsoft Universal Data Link (UDL) files.
Supports the connecting to ODBC sources.
Provides the special connection dialog for the most popular databases (Microsoft SQL Server, Oracle, Inprice Interbase, FireBird, Yaffil, MySql, Microsoft Access, Microsoft FoxPro, dBase, Microsoft Excel).
Supports saving an existing connection to a Microsoft Universal Data Link (UDL) file.
Displays tables, table views, store procedure list, system tables, and system views.
Allows to view and edit the existing rows and to insert new rows.
Allows to view and edit LONG TEXT and BLOB fields.
Provides the image management for BLOB fields.
Provides the quick database navigation and search.
Allows to export rows to an external file, or to copy them to the Clipboard.
Allows to view the table information (columns, indexes).
Allows to view the stored procedure information (parameters, columns).
Provides the stored procedure execution.
Provides the SQL queries execution.
Supports the SQL queries with parameters.
Provides the table management (create table, drop table, add column, alter column, drop column).
Provides the table view management (create view, drop view).
Provides the stored procedure management (create, drop procedure).
Provides the SELECT Query Wizard.
Provides the SQL editor with the syntax highlight.
Provides the 'read-only' and 'DB editing' work modes.
Displays query results as a plain text.
gipo-db_utilities gipo-db_explorer gipo-db_console database utilities db oracle sql server client mysql
|
 |
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 7.0, SQL Server 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 7.0, SQL Server 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.
Decrypts Objects of any size
Uses Unicode technology during the decryption process which allows for International use.
Simple point-and-click decryption. Does not require any T-SQL scripting knowledge.
Full T-SQL syntax highlighting for faster, easier reading.
Exports decrypted objects to SQL scripts or Rich Text Format (RTF) with syntax highlighting for easy portability and display to others.
Employs intelligent wizard technologies that allow for the decryption of entire databases with just a few simple mouse clicks.
Fully integrated WYSIWYG printing capabilities with T-SQL syntax highlighting.
Reduces time and money spent restoring lost source code to encrypted SQL objects. Never pay another developer to recreate and debug all of your lost SQL source code.
decrypt sql unencrypt decryptor unencryption decryption decode trigger view udf user defined function
|
 |
DBReader is a hierarchical database browser with editing capabilities.DBReader provides the end user with a fully integrated set of development tools for data manipulation and data definition. Complete with a metadata view of the underlying data structure, the end user is presented with a total overview of the data environment.
main features:
1.Connect to any datasource accesible via ADO using OLE DB Provider or ODBC.
2.Browse and edit database server-specific schema objects, including tables, fields, indexes, and stored procedure definitions(now only sqlserver).
3.Metadata View of tables and views with constraints and dependencies such as primary keys, foreign keys and indexes. Column details with datatypes, default values, nullability, etc.
4.Explore database structure in a tree (tables, views, columns, indexes, procedures, etc.)
5.Enter SQL statements to query a database, and edit the result set of a query.
6.View/Edit BLOB Field(plain text,RTF,image).
7.Run scripts of unlimited length. You can load SQL command from file or save SQL command to file.
8.Syntax Hi-lighting of keywords, string literals and comments.
9.Launch the ODBC Administrator to configure the ODBC Data Source Name.
db reader database editor db utility dbreader hierarchical database browser editing capabilities
|
 |
DBDocumentor produces programmers reference documentation on SQL Server databases. Working offline from the actual database, DBDocumentor covers all major object types including: functions, indices, procedures, tables (including columns and constraints), triggers, views, user defined types and security roles. Extended capabilities include full cross referencing of object access (e.g. which tables are used how and where), declarative object grouping, color syntax highlighting of source code, reporting of errors raised from stored procedures, which procedural objects are encrypted and/or use dynamic content and support for SQL Enterprise Manager object descriptions.
The output documentation is perfect as printed database documentation for clients, developers seeking to learn the structure of a new database, developers needing to understand databases structures prior to modification, dependency reports and quality assurance efforts to ensure coding guidelines are followed. Alternate output options include the SQLDocumentation XML schema and a choice of modern or classic MSDN layouts.
sql documentation sql reports documentation reports sql table index stored procedure constraint produce reference
|
 |
SQLHelp produces database documentation for the stored procedures in your database project. The documentation includes the input parameters, their types and directions, output result sets, executed procedures, return values, and transactional nature, independent of the path of execution. Extended capabilities include declarative procedure grouping, hyperlinked executed procedure access and query analyzer style syntax color coding. All documentation is generated via SQL batch files and requires no active database connection.
SQLHelp produced documentation is perfect as printed database documentation for clients, online access for middle tier developers to develop against a documented database interface and quality assurance efforts to ensure consistent coding guidelines are followed. SQLHelp documentation can also be produced at the beginning of projects to help define the interface contract between the database layer and its consumers.
In documenting the procedures as you design them, and by defining an interface contract, you can ensure the stability and reliability of your end application. SQLHelp produces compiled HTML Help formatted documentation that is familiar to virtually every developer working on Microsoft platforms.
Some of the capabilities include:
- Document SQL stored procedures easily and quickly.
- Define logical groupings of procedures.
- Produce compiled HTML Help of the procedures running on your database for future reference.
- Enforce object oriented design techniques by defining interfaces to your database.
- Limit access to the raw SQL to those who need access.
sql documentation stored procedure stored procedures annotation of sql produce reference documentation sql stored procedures
|
 |
SQL Source Control 2003 enables source control of code and documentation of your databases. Full source control and documentation versioning support is possible through integration with Visal Source Safe. Versioning is possible for each database item (tables, stored procedures, views, functions, triggers), including SQL scripts and documentation history.
You may create and version database documentation quick and easy, down to table columns or stored procedure parameters, generate reports in easy to read and share HTML format.
With built-in database management support users can browse, edit and remove existing items, add new tables, views, stored procedures, functions and triggers.
With exclusive checkouts developers may work together on the same database. They don't have to worry about possibility of several developers changing the same database object. Now each change is independely versioned and documented.
Deleted items management allows you to recover deleted database items from source control and put them back into your database.
SQL code editor features full syntax color coding to improve the readability of complex statements. Also included Intellisense-style automatic source code completion. Find/Replace with regular expressions support, line numbering.
You may also bring deleted SQL database items back to life. With deleted items management you may recover deleted database items from source control and put them back into your database.
sql server source safe sourcesafe source control database intellisense stored procedures sql safe management undelete
|
|
|
