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 ApexSQL 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.
- 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
- ApexSQL 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 ApexSQL 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
- ApexSQL 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 ApexSQL 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 ApexSQL Code)
"[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 backend. The Blaster writes both the ASP VBScript classes and the SQL Stored Procedures, a definite time-saver." ... Brian Johnson - MIS Manager - FSBDC Network.
ApexSQL Studio STANDARD
A SQL Lovers suite of 5 popular ApexSQL Products: ApexSQL Code, ApexSQL Audit, ApexSQL Clean, ApexSQL Diff and ApexSQL Script, at a discount of over 20% off the combined price of individual products.
ApexSQL Studio Downloads
ApexSQL Studio UNIVERSAL
A SQL Lovers suite of all 8 popular ApexSQL Products: ApexSQL Code, ApexSQL Audit, ApexSQL Script, ApexSQL Clean, ApexSQL Diff, ApexSQL Log and ApexSQL Report and ApexSQL 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 ApexSQL Report. Although they are both reporting tools, ASP Reports Freeware is a distinct product with no other relationship to ApexSQL Report.
» Application » Code generation tool - Apexsql based ... jr-s.biz/apexsql-code.htm