Apex-SQL Code: Template Based Code Generation for SQL Server

ApexSQL Code - "the next generation"
Radical new UI redesign, vastly improved Intelliprompt/Code-Complete, improved UI features and object model

The new version of ApexSQL Code was released on August 1st. It was basically re-coded from the ground up and has a totally re-designed interface.

RAD, Template Based Code Generation for SQL Server
What is ApexSQL Code? It's a Rapid Application Development Code Generation tool that allows you to point a Template to a SQL Object and from this automate the creation of complex code patterns for hundreds of objects in seconds. Practical applications are creating Insert, Update and Delete stored procedures based on tables, auditing triggers on tables, DAL middletier code based on stored procedures, documentation of all objects and more.

The key feature of Apex SQL Code is Template based code generation that allow users to configure custom code patterns automated with the scripting language of your choice, VBScript or JScript.

Don't wait for the higher priced new version! Buy now and get the upgrade for free.

ApexSQL Code - Features

New Auto-update feature
SQL 2005 Support
A template wizard that makes creating templates as easy as following 7 simple steps
A powerful template property page for editing templates in place with simple picklists and dialogs
XML based templates - allows for template attributes to be embedded directly in the template structure itself
Built in Session and Application variables
Programmatic control of file operations and dialogs directly from the template. Files can be output, appended or all file operations can be suppressed if user chooses to use File System Object
Apex SQL Code now automatically remembers all of your table, view, sproc, field, parameter and result column selection in between sessions and for a specific database. These selection profiles can be saved, cleared and retrieved
Choice of VBScript of JScript for template scripting - handles looping including For Each loops, constructs, error handling, etc. Your ability to create code patterns is virtually unlimited
Extensive template library including C#, VB.NET, AsP, VB, SQL and Delphi templates
Support for unlimited Include files just like ASP
Real Intellisense to navigate Apex SQL Code object Model
Default color coded text editor to manage templates currently supports ASP/VBScript, VB, Java/JScript, CSharp and SQL
Multiple tables, views and stored procedures can be scripted at once and even in the same template
Intelligent variable typing allows you to strongly type all VB variables (i.e. long), always use variants or use variants only for NULLABLE fields in the database
Scripting engine allows programmatic access to any COM object installed on user's computer including File System Object
Error handling shows exact line of error allowing for easy diagnosis of errors and de-bugging
Apex SQL Code object model allows easy extraction of information. Read-Only properties are used to create code patterns but object model also exposes Read-Write properties that can be controlled programmatically
Pre-Processing of templates - now various Apex SQL Code settings like language, programming language and output file can be controlled via the template itself
Templates can be Parsed for simple scripting mistakes like missing starting or closing tags and version incompatibilities

What's it For?
ust a few examples ...

Create Data Access layer code based on underlying tables, views or stored procedures
Create complete web forms in ASP.NET (C# and VB.NET) to work with your existing database
Automatically created stored procedures for select, update, delete and insert on tables
Construct an ADO Command object with parameters for large stored procedures with many input and output params
Document your sql server database into HTML by using database object scripts
Create a trigger based auditing system (templates included with Apex SQL Code)

Success Stories
"[ApexSQL Code] is one cool developer's tool! It has saved me weeks of coding and enabled RAD development of several of our web apps. We're running ASP with a SQL Server 2000 backend. The Blaster writes both the ASP VBScript classes and the SQL Stored Procedures, a definite time-saver." ... Brian Johnson - MIS Manager - FSBDC Network.

Apex SQL Studio STANDARD
A SQL Lovers suite of 5 popular ApexSQL Products: Apex SQL Code, Apex SQL Audit, Apex SQL Clean, Apex SQL Diff and Apex SQL Script, at a discount of over 20% off the combined price of individual products.

ApexSQL Studio Downloads

Apex SQL Studio UNIVERSAL
A SQL Lovers suite of all 8 popular Apex SQL Products: Apex SQL Code, Apex SQL Audit, Apex SQL Script, Apex SQL Clean, Apex SQL Diff, Apex SQL Log and Apex SQL Report and Apex SQL Edit at a discount of over 30% off the combined price of individual products.

ApexSQL Studio Universal Downloads

ASP Report Freeware
Data Driven Web Reporting.

ASP Report Freeware, web reporting sql tool, is a quick but powerful way to get your MS SQL Server data on the web. If you can write simple stored procedures you can give your users web based, data driven reports in minutes. Just set up the ASP-Report Freeware ASP source code on your web server and work with the online interface to set up web reports based on your existing layer of stored procedures and you are done. ASP-Report Freeware will manage criteria fields, report formatting, pagination and sorting automatically.

Best of all ASP Report Freeware is totally free. No components, dlls, encrypted ASP/VBScript code. All source is provided.

Note: ASP Report Freeware is NOT the eval, shareware version, demo, etc., for Apex SQL Report. Although they are both reporting tools, ASP Reports Freeware is a distinct product with no other relationship to Apex SQL Report.

Downloads ej-technologies - A privately held company - specialized in solutions that help programmers make the most of their own applications

mirabyte Super-HTML - Web/HTML-Editor, Disc-Starter - ein prof. Web-/Html-Editor - Rss Crawler + Disc Starter

Si-Components - Multi Screen Emulator for Windows - Resource Builder - Reg Keeper e-Sales Tracking - VCL Scheduling Agent - Tsi-Lang Components Suite

NAMO Software Downloads - A leading developer and global supplier of software solutions - for the World Wide Web

Download Privacy-Ware Soft - Entwicklung von It-Management-Software - Privacy-Ware - security software provider