SQL Assistant 6.2.109 is now available

SQL Assistant 6.2.109 is now available

Build 6.2.109 is now available for download

This maintenance release contains several new significant features, tons of minor enhancements and bug fixes

Here is a list of new features and enhancements in version 6.2
===========================================
1. Bulk SQL code generator with ready to use templates for generating CRUD procedures.
2. Easy Excel data export / import to and from database.
3. Hierarchical and flat XML data export / import .
4. Improved SQL Intellisense – automatic and suggested corrections for misspelled keywords, names, parameters, etc…
5. Improved SQL Intellisense – suggestions for code generating code snippets.
6. New set of add-ons for SQL Server Management Studio 2005, 2008, 2012 for SQL Assistant integration with the Database Object Explorer.
7. Updated Visual Studio 2010 add-ons extending support to VS2010 Ultimate Edition
8. Referential integrity rules checking added to dependencies analyzer and smart database refactoring methods.
9. Multi-server multi-database Code search.
10. Multi-server multi-database Data search.
11. Mouse-over hints for schema and database names with statistical info and action links.
12. Support for MDX windows and queries in SQL Server Management Studio.
13. Auto-bookmarks from specially formatted script comments.
14. Enhancements in macro-script parameters processing, new options for getting updatable columns and key based columns.
15. Auto-highlighting performance costliest operations and steps in Query Execution Plans.
16. DDL code reverse-engineering now supports object and column based comments.

Lots of other minor changes and enhancements.

* list of changes in version 6.1
* list of changes in version 6.0

Last edited by SysOp on Thu Dec 06, 2012 3:57 pm; edited 3 times in total

Many interesting new features and changes to existing ones. Especially the $OBJECT(...)$ like extensions to $COLUMNS(...)$ and $ARGS(...)$ will result in lots of updates to my existing snippets. Both Data and Code Search looks promising and Auto-bookmarks was long-awaited. It's simply awesome :)

Is it possible to alter DB Queries so that triggers are listed in popup when filtering for procedures and/or introducing them as an independent class for $OBJECT(...)$ macro?

Hi. Thank you for your feedback. Triggers can be listed as procedures by modifying the "Objects (MSSQL) + Typed Synonyms" query, yet I'm not sure that's what you are looking for.

To add triggers to the query change it as the following

Code:

if @@version like 'Microsoft SQL Server 2005%'
or @@version like 'Microsoft SQL Server 2008%'
or @@version like '%SQL Server 2012%'
or @@version like '%Denali%'
select
name, CASE WHEN type = 'SN' THEN '^' +
CASE CAST(OBJECTPROPERTYEX(object_id,'BaseType') AS VARCHAR)
WHEN 'AF' THEN 'F'
WHEN 'FN' THEN 'F'
WHEN 'FS' THEN 'F'
WHEN 'FT' THEN 'U'
WHEN 'IF' THEN 'U'
WHEN 'IT' THEN 'T'
WHEN 'P' THEN 'P'
WHEN 'PC' THEN 'P'
WHEN 'TR' THEN 'P'
WHEN 'S' THEN 'T'
WHEN 'SQ' THEN 'I'
WHEN 'TF' THEN 'U'
WHEN 'TT' THEN 'K'
WHEN 'U' THEN 'T'
WHEN 'V' THEN 'V'
WHEN 'X' THEN 'P'
ELSE ' '
END
ELSE CASE type WHEN 'TR' THEN 'P' ELSE type END END,
object_id, create_date, modify_date
from
[$DB_NAME$].sys.all_objects
where
type in ('U','S','V','P','X','RF','FN','TF','IF','SN','PC','FT','FS', 'TR')
and (
schema_id = :SCHEMA_ID
or (
1 = :SCHEMA_ID
and user_name() = 'dbo'
and schema_id = 4
and name in ('sysobjects','sysindexes','syscolumns','systypes','syscomments','sysfiles1','syspermissions','sysusers',
'sysproperties','sysdepends','sysreferences','sysfulltextcatalogs','sysindexkeys','sysforeignkeys',
'sysmembers','sysprotects','sysfulltextnotify','sysfiles','sysfilegroups')
)
)
and not (name = 'dtproperties')
and not (name like 'dt%' and type = 'P')
else
select
name, xtype, id, crdate, crdate
from
[$DB_NAME$].dbo.sysobjects
where
xtype in ('U','S','V','P','X','RF','FN','TF','IF')
and uid = :SCHEMA_ID
and not (name = 'dtproperties')
and not (name like 'dt%' and xtype = 'P')

Last edited by SysOp on Mon Jun 11, 2012 1:54 pm; edited 1 time in total

Exactly what I need, thanks. I have an 'edit' snippet that retrieves the creation code for modification for all kinds of object and the only way I could do that to triggers was to select the table and retrieve all the triggers. Now I can do that for every trigger separately. Incomparably faster than hunting through Object Explorer tree, right clicking object and then traverse several submenus and sub-submenus etc. to get the code into the editor.

Installing 6.2 blew away my configuration including my custom code formatting style.

	anildas wrote:
	Installing 6.2 blew away my configuration including my custom code formatting style.

What version did you install it on? If it was 6.1 then your config is in "C:\Users\<you>\AppData\Roaming\SQL Assistant". You can restore relevant parts from there.

Please use Import / Export feature in the Options dialog to import relevant parts. Do not import the entire file otherwise you will loose new code generation snippets and some other important settings. Basically if you import everything, certain new features will be disabled as they depend on the new settings.

Thank you.

I see in the forum that there is an update for vs2010 ultimate - but when i check for updates via the sql assistant icon, it says there is none. i am running licensed 6.2.112 standard. How can i get the update?

As of today version 6.2.112 is the latest available.

If you have an issue with VS 2010 Ultimate, please describe it in a separate topic.