SQL Prompt 6.3 beta (Now closed)

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

SQL Prompt 6.3 beta (Now closed)

Postby Aaron Law » Thu Jan 23, 2014 4:34 pm

Beta closed - thanks to everyone who took part!


This latest beta build of SQL Prompt includes:

New features
  • Select in Object Explorer (context menu as well as Ctrl + F12) (UserVoice)
  • Many improvements to our SQL grammar
  • UpperCamelCase & lowerCamelCase casing options
  • Highlighting matching parentheses (UserVoice)
  • Template parameter dialog box now opens automatically if a snippet has parameters (Forum post)
  • $SELECTIONSTART$ and $SELECTIONEND$ snippet placeholders (Documentation)
  • Improvements to when Prompt suggestions box is displayed (suggestions are now displayed if you continue to type a half completed word)
  • Pressing Enter after GO now enters a new line
  • Inserted and Deleted tables now suggested for triggers (and now resolve to correct table in other statements) (UserVoice)
  • String constant suggestions for SERVERPROPERTY, FILEPROPERTY, DATABASEPROPERTYEX, etc
  • Suggestions box now auto-hides when there are no suggestions
  • Partial matching system improvements (UserVoice)
  • More suggestions for new 2014 syntax
  • Show schema names button state is now saved (UserVoice and UserVoice)
New in 6.3.0.294
  • Suggestions box delay option added (UserVoice)
  • More documentation for built-in functions
  • More string literal suggestions
Feedback
If you encounter any issues with the beta, post them on this forum.

If you have any suggestions for improvements to SQL Prompt, post them on our suggestions forum.


Bug fix version history

6.3.0.252
  • Columns suggested first in search conditions (eg WHERE and HAVING) (Forum post)
  • Auto-completed functions won't insert closing parenthesis if directly before a column (eg. \"SUM(Column\" instead of \"SUM()Column\")
  • Column names on expand wildcard are no longer qualified with schema names
  • Fixes for several bugs that were sent to us as error reports from SQL Prompt
6.3.0.240
  • Improved suggestions after errors in script (Forum post)
  • Improved suggestion ordering (Forum post)
  • Minor performance improvements
6.3.0.188
  • Select in object explorer now selects objects on a connected linked server (Forum post)
  • Select in object explorer now works with table types and table-valued functions (Forum post)
  • Fix for \"value\" stopping suggestions (Forum post)
  • Fix for suggestions stopping (Forum post)
  • Fix for SP-4994 (Unable to load DLL 'SQLite.Interop.dll')
  • Fix for SP-3598 & SP-4984 (Very large encrypted stored procedures are not decrypted properly)
6.3.0.121
6.3.0.102
  • Auto generated insert statements now use GETDATE() instead of a string literal (UserVoice)
6.3.0.100
  • Fix for CamelCase datatypes enclosed in square brackets
  • Fix for SP-5013 (NullReferenceException)
6.3.0.95
  • Fix for xml casing (Forum post)
  • Fix for select in object explorer failing in SSMS2008R2 (SP-5006/\"Field 'Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.hierarchies' not found.\")
  • A few missing suggestions added for built in functions
6.3.0.70
  • Auto generated insert statements with hints and a semicolon will keep the hints/semicolon (Forum post)
6.3.0.66
  • Fix for missing options (eg custom aliases)
6.3.0.65
  • Fix for snippet $SELECTIONSTART$ selecting wrong text across multiple lines with indentation
  • Select in object explorer works if the cursor is on a semi-colon (Forum post)
  • Insert statements keep the table hints with the name when generating insert code (Forum post)
  • More grammar fixes
6.3.0.39
  • Fix for keywords occasionally not being recased (Forum post)
  • Fix for wrong suggestion being selected
  • Fix for ‘left’ not being cased correctly (Forum post)
  • Master database is enclosed with square brackets if the option is set
  • Various keyword casing fixes
  • Fixed the following bugs that were sent to us as error reports from SQL Prompt: SP-3556, SP-4388, SP-3680, SP-3860, SP-4258, SP-4379, SP-4192, SP-3545, SP-4948, SP-4982
Last edited by Aaron Law on Tue Apr 08, 2014 3:07 pm, edited 16 times in total.
Aaron Law
 
Posts: 261
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby PDinCA » Sat Jan 25, 2014 12:22 am

Option to turn OFF bracket-matching, please?

I find that SSMS Intellisense limited to code blocks and bracket-matching works extremely well with SQL Prompt. I wouldn't like to see the two products argue over who will highlight a bracket, or not.

Thanks.
PDinCA
 
Posts: 516
Joined: Mon Jul 25, 2005 11:42 pm
Location: Costa Mesa, CA, USA

Postby Aaron Law » Mon Jan 27, 2014 12:58 pm

Hi Stephen,

I don't think they argue over who gets to highlight a parenthesis, if you do notice any issues please let us know and we'll fix them.
Aaron Law
 
Posts: 261
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

XML Nodes Method

Postby JBSandhills » Wed Jan 29, 2014 12:32 am

When formatting SQL XML statement like the following with the XML method "nodes" on my computer, nodes becomes capitalized, and this capitalization causes the query to fail. Also, I noticed that formatting puts a space between the "T" and "(x)". I don't remember that happening in previous versions.

[u]It should be:[/u]
SELECT T.x.value('./@Value1', 'INT'), T.x.value('./@Value2', 'INT')
FROM @XMLVariable.nodes('RawData/RawDataRecord') AS T(x)

[u]After formatting:[/u]
SELECT T.x.value('./@Value1', 'INT'), T.x.value('./@Value2', 'INT')
FROM @XMLVariable.NODES('RawData/RawDataRecord') AS T (x)

I never had problems with the node keyword or its alias before the beta, so I think it might be a bug. Can you please have someone look into it?

Thanks.
JBSandhills
 
Posts: 2
Joined: Wed Jan 29, 2014 12:15 am

Postby Aaron Law » Wed Jan 29, 2014 10:59 am

Hi JBSandhills,
Thanks for reporting this - I can recreate the "nodes" being uppercased and will look into a fix for you.

For the space between the T and the (x) I think that it might have always been like that (I just gave it a try 6.2 and 5.3). Is this something you'd want changed?
Aaron Law
 
Posts: 261
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby JBSandhills » Wed Jan 29, 2014 3:43 pm

Hi Aaron,
It would be nice to have the space removed because it looks a bit strange; however, it's not the end of the world if this feature has to come sometime later. As long as the NODES issue is fixed by stable release, my coworkers and I will be very happy.
JBSandhills
 
Posts: 2
Joined: Wed Jan 29, 2014 12:15 am

Postby Aaron Law » Thu Jan 30, 2014 3:04 pm

The xml casing should be fixed for you in 6.3.0.95.
Aaron Law
 
Posts: 261
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby Mr.DiGi » Thu Feb 06, 2014 2:13 pm

Microsoft SQL Server Management Studio 11.0.3401.0
SQL Prompt Pro 6.3.0.102
SQL Search 1.1.9.57
SSMS Tools Pack 2.7.2.0

Instant crash after typing number after GO. In SSMS you can specify how many times should SSMS repeat statement.

Code: Select all
PRINT 'You will see this message 10 times'
GO 10


This works fine with SQL Prompt 6.2.

Edit: Yay, just paste example in SSMS and...
Mr.DiGi
 
Posts: 4
Joined: Thu Feb 06, 2014 2:05 pm

Postby Aaron Law » Thu Feb 06, 2014 3:26 pm

Hi Mr.DiGi,

I'm really sorry you've encountered this crash but thank you for reporting it. I can recreate it here and will look into a fix for you, hopefully I'll have a new build out shortly.

Thanks,
Aaron.
Aaron Law
 
Posts: 261
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby Aaron Law » Thu Feb 06, 2014 6:05 pm

I've just uploaded 6.3.0.121 which should have a fix for this crash. Thanks again for reporting it!
Aaron Law
 
Posts: 261
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby Mr.DiGi » Fri Feb 07, 2014 10:33 am

No problem, thanks for quick fix.
Mr.DiGi
 
Posts: 4
Joined: Thu Feb 06, 2014 2:05 pm

Postby Mr.DiGi » Fri Feb 07, 2014 11:50 am

More (minor) bugs - User defined table type related:

- Select in Object Explorer is not working for table type
- column names from table type are not listed (maybe this didn't work with previous version too)
- we have custom table type with "Value INT" column. After using column "Value" in join all database object/names disappears from SQL Prompt (only snippets are listed).

demo:

Code: Select all
CREATE TYPE [dbo].[IntTable] AS TABLE
(
   [ID] [int] IDENTITY(1,1) NOT NULL,
   [Value] [int] NULL
)
GO

DECLARE
   @x dbo.IntTable

SELECT
   1
FROM
   @x AS X
   INNER JOIN sys.objects AS O ON O.object_id = X.Value
   INNER JOIN <no hint here>


Just changing "O.object_id = X.Value" to (invalid) "O.object_id = X.ValueZZZ" brings SQL Prompt back.

Edit: Or we can use O.object_id = X.[Value] - maybe because XML type .value, .nodes hacks?
Mr.DiGi
 
Posts: 4
Joined: Thu Feb 06, 2014 2:05 pm

Postby Aaron Law » Fri Feb 07, 2014 5:12 pm

Thanks for reporting these, I can recreate them here and we're looking into fixes for them.

I think you are right about the value being mixed up with the xml type value and so Prompt is wrongly expecting parentheses and parameters, which results in it not giving you the correct suggestions.
Aaron Law
 
Posts: 261
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby Aaron Law » Fri Feb 28, 2014 11:37 am

Hi Mr DiGi,
Just to let you know, the bugs you mentioned in your last post should be fixed in 6.3.0.188.

Thanks,
Aaron.
Aaron Law
 
Posts: 261
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby Mr.DiGi » Wed Mar 05, 2014 10:34 pm

Awesome, thanks for fixes.

OT: Is there any way to log/debug Qualify object names call? It just hang for our db (almost since beginning).

No error in "....\\AppData\\Local\\Red Gate\\SQL Prompt 6\\sqlpromptlog-yyyymmdd-hhmmss.log"
Mr.DiGi
 
Posts: 4
Joined: Thu Feb 06, 2014 2:05 pm

Next

Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 0 guests