A & G: AGS SQL Scribe Enterprise, Cross-Tab, Columnby - Column by 90 - Extended Stored Procedure
xp_ags_colby 90_2000 will transpose multiple rows of a single column into one single row. Now you can show multiple child records on a single line of the parent record.
Using the included user defined function allows you to call the extended stored procedure from within a SQL statement.
A program designed to help you as a DBA manage and check the data integrity of your database.
- The ability to draw you database tables and relationships
- Create virtual relationships where exiting relationships are no possible
- Compare table design against different servers and databases
- Export drawings to image files
- Validate data integrity on multiple database systems
- Import existing relationships from your databases
- Automatically create relationships based on table names and column types
- AGS SQL Data Assistant is a tool designed to make your life as a DBA easier
A documentation tool created with the developer in mind. SQL Scribe will interrogate a SQL database and extract the database schema. This schema information is stored in an MS Access database. Using any readily available browser the developers can navigate though the system documentation which is laid out in a easy to read and logical way.
With SQL Scribe 90% of your system documentation is complete. Using the included User documentation tool you can add your own user documentation as well. You can re-run the Schema Extraction process as many times as you need, without losing your user documentation.
Using IIS and MTS to generate the HTML pages means that hundreds of developers and end-users can access your documentation. All HTML pages are cross indexed and linked. This means that with one click you can go from looking at Table documentation to looking at a dependant Stored Procedure. Finding all the dependant object has never been so easy.
WEB Hosting site that support Microsoft SQL Server, you can add online documentation as part of your system with one simple and in-expensive purchase. Just schedule the Schema Extraction process to run nightly and they will alway have up-to-date documentation.
SQL Scribe Feature
- Reverse engineer any SQL database
- Full dependant list and SQL Script for every object
- Title search for any object
- Browser independent i.e. Use MS IE , Netscape,
- All pages cross reference and link to all SQL objects on
- Offline storage of your SQL Script. This can be used for disaster recovery purposes
- Deploy the WEB object to your clients at no cost. In this way you can included system documentation to your clients
- Colour and Style is controlled by Style sheets. This means you can customize the look and feel to suit your needs
- SQL Scribe is licensed per organisation. So with one in-expensive purchase you can document ALL of your databases on ALL of your servers no mater how many servers or databases you have. Database Service Providers (organisations who supply Database server services to other organisation) are required to purchase two licenses at a discounted price. One for themselves and one for all of there clients. See license agreement for more details
Load any VB SDI form into its container window.
The AGS Subform can be housed by any of the VB containers, which allows you to place it on a MDI main form. IF the loaded form is larger than the AGS Subform component then scrollbars will automatically appear to allow navigation of the loaded form. Two sets of borders allow you to change the thickness and type of borders from none to thing and 3D. Now you can add MS Access Subforms like screens to your visual basic programs. Used in conjunction with your toolbars control to create outlook like screens.
A package of Functions and Stored Procedures for Microsoft SQL Server 2005.
Written using SQL CLR these functions have only been seen before using complex TSQL or Extended Properties. These functions are brilliantly quick and simple to use. Please see the list of functions below.
AGS SQL Server Utilities: String Functions
- AGS Split-String
This function will return a sub string from a delimetered input string. Simply pass the input string, the delimeter, the output string and index to return
- AGS Format-Date
This function will format a Date value using string formatting syntax. This is more robust than TSQL convert
- AGS Format-Number
This will format a number using string formatting syntax
AGS SQL Server Utilities Compression
- AGS Compress
This will compress a value and return a varbinary value. If the length of the item compress is smaller than the compressed varbinary then the orginal value is returned in a varbinary format
- AGS De-Compress
This will decompress a varbinary value previously compressed with AGS_Compress and return a sql_variant with a subtype of the orginal value
License Details: With you purchase of AGS SQL Server 2005 Utilities you get unlimited support calls (via email) and ONE YEAR free unlimited upgrades. So no matter how often or what we upgrade in AGS SQL Server 2005 Utilites you will get it for ONE YEAR free.
Extending SQL Server abilities.
This extended stored procedure will generate crosstab results from standard SQL statements. You now do not have to run OLAP services to generate what Microsoft Access has been able to do for years. See the Online instructions for an example of what xp_ags_crosstab can do
Have your web site independently reviewed by our team.
A & G Software has developed an independent evaluation process which will inform you of key areas of concern with your web site.
On completion of the analysis you will receive a detailed report on:
- Major search engine placement
- Visibility of your web site
- Product Profile
- Comparison against competitor's products
- Links from Other Web Sites
- Advertising placement
- News Group/Forums activity
Reviews take from 1 to 2 weeks to complete, due to the high demand on our resources. After purchasing please follow the instructions in the confirmation email to start the process
. Customers purchasing via purchase orders will have their review processed after payment is made.
» Column » AGS sql scribe - Crosstab/Column ... jr-s.biz/ags-sql.htm