SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Assistant 6.2.109 is now available

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SQL Assistant 6.2.109 is now available
Author Message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post SQL Assistant 6.2.109 is now available Reply with quote
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
Sat Jun 09, 2012 8:26 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1400

Post Reply with quote
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?
Sun Jun 10, 2012 5:04 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
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
Sun Jun 10, 2012 11:51 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1400

Post Reply with quote
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.
Mon Jun 11, 2012 3:22 am View user's profile Send private message
anildas



Joined: 14 Nov 2007
Posts: 69
Country: United States

Post Reply with quote
Installing 6.2 blew away my configuration including my custom code formatting style.
Wed Jun 13, 2012 1:26 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1400

Post Reply with quote
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.
Wed Jun 13, 2012 1:42 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
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.
Wed Jun 13, 2012 1:53 pm View user's profile Send private message
GeneW



Joined: 10 Apr 2012
Posts: 18
Country: United States

Post update that supports vs2010 ultimate Reply with quote
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?
Wed Aug 15, 2012 4:34 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
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.
Wed Aug 15, 2012 4:54 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.