 |
The Regular Expressions for MS SQL Server is a set of T-SQL User Defined Functions (UDF) that gives users full power to manipulate string data in SQL queries, stored procedures and Transact-SQL programming. Some of the common challenges that you can solve with the Regular Expressions are:
? Extracting information and data mining;
? Formatting string data;
? Parsing text data into sections;
? Validating user text input; password, e-mail, URL, ect.;
? Replacing values in text to clean or change content.
Features of the product are:
? easy to use;
? great productivity and reliability;
? 100% Unicode;
? 100% compatible with VBScript regular expressions;
? works with (N)CHAR and (N)VARCHAR data;
? 30 days free trail period of the full product version.
regular expressions ms sql server 2000 t-sql vbscript regexp udf user
|
 |
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
|
 |
Database Web Explorer is an universal Web-based database manager intended to work with DBMS in Internet/Intranet networks. Database Web Explorer allows you to manipulate the data stored in databases via Internet. As programm of the remote access the usual Web-browser is used. Database Web Explorer was developed with ASP technology in pure script language and does not required installation of any additional COM-components, DLL or ActiveX neither on the Web-server nor on the computer of the user. Database Web Explorer is distributed in source codes - HTML and JavaScript. Supports connections to databases through ODBC drivers and OLE DB providers. Configuration and installation of Database Web Explorer is very easy. The product works under the Web-server Microsoft Internet Information Server.
Common features:
- Very easy installation, configuration and usage
- Supports the multiuser work with DBMS
- Does not required installation of any additional COM-components, DLL or ActiveX neither on the Web-server nor on the computer of the user
- As programm of the remote access the usual Web-browser is used
- Supports connections to databases through ODBC drivers and OLE DB providers
- Compact code in pure script language
Database Web Explorer allows you:
- Connect to any DBMS via ODBC or OLE DB
- View names of tables, fields, indexes and stored procedures in database
- View definitions of fields and indexes of tables in database
- View data in tables in database
- Export data in tables to MS Excel and as SQL-script
- Add, edit and delete record in tables in database
- Execute SQL-queries to database
- Export results of queries to MS Excel
database dbms sql sql query sql explorer sql tools odbc connection
|
 |
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
|
 |
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
|
 |
RFG Software is the publisher of CG Pro, which is a sophisticated code generation tool. CG Pro generates a full n-tier application based upon existing Microsoft SQL Server databases. The supported application types are Microsoft Windows, ASPX web based solutions and Web services. Generated solutions include native support for XML, import and export functionality as well as support for exporting to Microsoft Excel. A 30 day trial is available at www.rfgsoftware.com
code generation code generator cg pro vb vb -net templates data access facia objects user interface stored procedures xml
|
 |
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
|
|
|
