SQL Prompt v4 EAP

• 
  Thanks Tanya (and David for the email notification)
  
  
  Congrats on a new 4.x version, WOO HOO!
  Felt like 3.8/3.9 was eternity
  
  While not wanting to affect my current 3.9 setup (which works great), gotta find a new environment to test this out
  
  Question
  - how long is the build good for? expiry date?
  
  
  Thanks, keep up the good work

  jerryhung May 29, 2009 11:36

  - 0 +
• 
  Will this carry over my settings from 3.x?

  swrobel May 29, 2009 13:52

  - 0 +
• 
  NO ALIASES ARE CARRIED OVER!

  PDinCA May 29, 2009 13:56

  - 0 +
• 
  Hello,
  
  Nope. SQL Prompt v4.0 installs in a separate directory and does not port any of your v3.x settings. However, we do have an executable that will be made available shortly for porting your snippets from v3.x to v4.0.
  Hope that helps!
  
  Thanks,
  Tanya
  Project Manager
  Red Gate Software Ltd

  tanya May 29, 2009 20:27

  - 0 +
• 
  Is there any way to make it stop putting [] around table names? 3.x didn't do that for me...

  swrobel May 29, 2009 20:32

  - 0 +
• 
  May I, politely but firmly, say that porting Aliases is equally, if not more, important than snippets. Many of us rest with the standard set that come as part of v3.9 so we essentially have no need of the executable you mention.
  
  However, re-typing a list of 160 Aliases, and growing, is a completely unacceptable task to expect us to manually undertake for a product upgrade.
  
  Please reconsider priorities towards porting Aliases, rather than snippets.
  
  Respectfully,
  
  Stephen

  PDinCA May 29, 2009 20:33

  - 0 +
• 
  For me, the snippets are much more important (and involve much more work) than the aliases.
  
  Regards,
  Alex

  Alex Fekken June 01, 2009 01:06

  - 0 +
• 

  swrobel wrote:

  Is there any way to make it stop putting [] around table names? 3.x didn't do that for me...

  
  Please ensure that the option
  Sql Prompt 4 > Options > Inserted Code > Special characters > Enclose identifiers within square brackets [] is unchecked.
  
  If it is unchecked, then Sql Prompt should only surround tables with square brackets if there is a sql keyword with the same name therefore making them totally unambiguous.
  
  Can you give an example of a query where this is happening?

  Chris George June 01, 2009 03:57

  - 0 +
• 
  Just to add my vote to this: I will be very pleased to see the app for transferring the snippets.

  fatherjack2 June 01, 2009 06:08

  - 0 +
• 
  Hello,
  
  Totally understand the issue. We will review this for the final release and keep you posted with updates regarding this.
  
  Thank you for your patience.
  
  Regards,
  Tanya
  Project Manager
  Red Gate Software Ltd
  

  PDinCA wrote:

  May I, politely but firmly, say that porting Aliases is equally, if not more, important than snippets. Many of us rest with the standard set that come as part of v3.9 so we essentially have no need of the executable you mention.
  
  However, re-typing a list of 160 Aliases, and growing, is a completely unacceptable task to expect us to manually undertake for a product upgrade.
  
  Please reconsider priorities towards porting Aliases, rather than snippets.
  
  Respectfully,
  
  Stephen

  tanya June 01, 2009 06:32

  - 0 +
• 
  I hope this version is better. Just about everytime I start into a large SP, the intellisense mid way through gets confused and stops working... Hoping for the best...

  rtaylor72 June 01, 2009 15:00

  - 0 +
• 
  I seem to have had an issue installing. It looks like I've had sql server express on my PC in the past, and currently have SQL Server Management Studio. An error message appears stating that express will now close (thansk but it wasn't open) and then the installer hangs, but eventually completes.
  
  Still seems to work - just thought I'd let you know.

  digiguru June 02, 2009 04:30

  - 0 +
• 
  The comment ... Note: Offline working is not supported in the new version. ... has me worried
  
  Do you mean it won't work with a working internet connection ?
  - I work on my laptop with a local database, and I often don't have internet.

  steveculshaw June 02, 2009 04:43

  - 0 +
• 
  Hello,
  
  Thank you for taking the time to report the issue.
  Towards the completion of the installation, the installer goes through some stages wherein it runs Visual Studio to get the install process completed. This causes the hang perception and it is something we intend to look into in the future (not for v4 release)
  However, the error message that you received is bizarre and we will look into it.
  
  Excuse us for the inconvenience caused and thanks again for the feedback:)
  
  Regards,
  Tanya
  Project Manager
  Red Gate Software Ltd
  
  

  digiguru wrote:

  I seem to have had an issue installing. It looks like I've had sql server express on my PC in the past, and currently have SQL Server Management Studio. An error message appears stating that express will now close (thansk but it wasn't open) and then the installer hangs, but eventually completes.
  
  Still seems to work - just thought I'd let you know.

  tanya June 02, 2009 05:09

  - 0 +
• 
  Hi Steve,
  
  The requirement for SQL Prompt to be able to provide suggestions is that you need to be actively connected to the database server.
  So, if you are working on a local database and not connected to internet, SQL Prompt will continue to work fine. However, if your database server is located in a remote server, then internet connection is essential.
  
  I hope that helps.
  
  Thanks,
  Tanya
  Project Manager
  Red Gate Software Ltd
  

  steveculshaw wrote:

  The comment ... Note: Offline working is not supported in the new version. ... has me worried
  
  Do you mean it won't work with a working internet connection ?
  - I work on my laptop with a local database, and I often don't have internet.

  tanya June 02, 2009 06:20

  - 0 +
• 
  Tanya,
  
  maybe ... when I say "local", I mean from my laptop to one or more virtual machine, hosted either on my laptop or on another machine in my study.
  
  Will this mean "internet connection is essential" ?
  - because if it does, then I'm going to have serious problems
  
  I know the "always on" connection is coming, but it's not here yet, so is there anyway to ameliorate the "internet connection is essential" requirement ?

  steveculshaw June 02, 2009 07:21

  - 0 +
• 
  Steve,
  
  Put simply, to use SQL Prompt you must have a connection to the database you wish to work on.
  
  We do not support "offline" working where SQL Prompt would continue to provide suggestions even though there was no connection to the database.
  
  The internet connection is only essential if your database resides somewhere remote to your location which needs an internet connection to access that database.
  
  So, as long as your database can be connected via your own LAN, then you do not need an internet connection.
  
  I hope this clears up the confusion :-)
  
  
  Regards
  
  Chris

  Chris George June 02, 2009 11:12

  - 0 +
• 
  So what’s new?
  • Snippet manager access isn't under 'options' anymore, so if your normal path is 'open up Query Analyzer' then 'access things you need to change thru Options off the tray', you'll be wondering WTF happened to your snippets.

  Jadawin June 02, 2009 17:11

  - 0 +
• 
  Thanks Chris, that good news
  
  Right off to download and install

  steveculshaw June 03, 2009 01:14

  - 0 +
• 
  Hi Jerry,
  
  The build will expire on 10th July 2009.
  
  Thanks,
  Tanya
  Project Manager
  Red Gate Software Ltd
  

  jerryhung wrote:

  Thanks Tanya (and David for the email notification)
  
  
  Congrats on a new 4.x version, WOO HOO!
  Felt like 3.8/3.9 was eternity
  
  While not wanting to affect my current 3.9 setup (which works great), gotta find a new environment to test this out
  
  Question
  - how long is the build good for? expiry date?
  
  
  Thanks, keep up the good work

  tanya June 03, 2009 09:13

  - 0 +
• 
  love alot of the new enhancements.
  
  There's one issue I keep running into though that I dont recall having in the previous version. I use the TAB key exclusively to do auto insertion & snippets.
  
  The issue I'm having occurs when for example I want to include the column IsDeleted in my select statement. I type in SELECT is which brings up the Suggestion box with the list of columns, I highlight IsDeleted and press TAB but instead of getting the IsDeleted column I get the snippet INFORMATION_SCHEMA. Another example, I want to select the column ApolloId, type in SELECT ap but instead of getting the selected ApolloId I get ALTER PROCEDURE.
  
  I hardly ever use INFORMATION_SCHEMA or have to type in ALTER PROCEDURE so the work around for these specific cases was to modify the snippet. However, I think that if the suggestion window is present and you have an item selected in it that selection should take precedence over any snippets.
  
  Hope you can look into this issue before the final realease.

  ceacl June 03, 2009 18:57

  - 0 +
• 
  I have noticed the above scenario but had put it down to something I had done previously. Will look for it again and give more precise details.
  
  v3 used to do something similar - something like, if you didnt use the autofill in one place in the script and then type 'SELECT ... FROM Orders ' the alias autofill would complete the line with 'AS wher'
  
  Has anyone else noticed that the syntax checker is more strict? The red wavy lines are taking over!
  
  Jonathan

  fatherjack2 June 04, 2009 04:31

  - 0 +
• 
  GO [count] is not supported in SQL Prompt and displays "SQL syntax error". (GO without [count] works ok)

  George Palacean June 04, 2009 05:05

  - 0 +
• 
  Aliases:
  I just had occasion to reference the sys.databases table.
  I typed "SELECT * FROM [sys].[databases]" and the alias text was added as " AS d1". In my font this is indistinguishable from dl and dI. (There may also be a strong case for me needing to use a grown-up font here.)
  
  There were no other aliases in use - one query file open, one query on the page - so why did it not use just 'd'? Is there a setting to prevent numbers being used in aliases.
  
  Closing characters:
  none of mine close ... ', ", /*, ), ] (even after changing all the settings off and back on yesterday and shutdown/restart this morning)

  fatherjack2 June 04, 2009 05:17

  - 0 +
• 
  Is it possible to make SQL Prompt NOT format the source code of the procedure when it auto-completes the alter procedure statement ?
  I couldn't find any option for this

  George Palacean June 04, 2009 10:03

  - 0 +
• 
  I have had 3 occasions today where I have take the script of an object (hover over name and Copy script from popup window) and pasted it into a new SSMS query and the formatting has been all left justified.
  
  Ctrl K, Y only keeps it there,
  
  Ctrl B,L indents it as 'normal'.
  
  Subsequent Ctrl K,Y left justifies everything

  fatherjack2 June 04, 2009 10:16

  - 0 +
• 
  A very strange thing:
  
  When SQL Prompt 4 is enabled, double-clicking a word in SSMS 2008 doesn't select it entirely, it stops at underscores.
  
  For example, double-clicking SP_HELP selects either 'SP', '_' or 'HELP' (depending on the mouse position), instead of the whole procedure name.
  
  This happens only as long as SQL Prompt is enabled.
  
  
  By the way, why has the quick menu option to disable SQL Prompt disappeared ? Now it can only be disabled by going to SQL Prompt->Options

  George Palacean June 04, 2009 11:37

  - 0 +
• 
  Can confirm comments by George Palacean above.
  
  Its also odd when you Ctrl and left arrow or Ctrl + right arrow.
  
  If you happen to have left a section of text without a closed comment (' or ") then the cursor jumps to the opening character or to the end of the line, it ignores spaces entirely.

  fatherjack2 June 04, 2009 11:45

  - 0 +
• 
  SQL Prompt 4 is not auto-uppercasing keywords for me like SQL Prompt 3 did. In SQL Prompt 3 I didn't have to tab it out, it just uppercased it after I finished typing the keyword.
  
  EDIT: and yes, I do have Format > Case > Reserved Keywords set to UPPERCASE

  swrobel June 09, 2009 14:31

  - 0 +
• 
  Hello,
  
  I am glad you like the new version:)
  We are looking into the issue and will have it addressed for the beta/release.
  
  Thank you for bringing the issue to our notice.
  
  Regards,
  Tanya
  Project Manager
  Red Gate Software Ltd
  

  ceacl wrote:

  love alot of the new enhancements.
  
  There's one issue I keep running into though that I dont recall having in the previous version. I use the TAB key exclusively to do auto insertion & snippets.
  
  The issue I'm having occurs when for example I want to include the column IsDeleted in my select statement. I type in SELECT is which brings up the Suggestion box with the list of columns, I highlight IsDeleted and press TAB but instead of getting the IsDeleted column I get the snippet INFORMATION_SCHEMA. Another example, I want to select the column ApolloId, type in SELECT ap but instead of getting the selected ApolloId I get ALTER PROCEDURE.
  
  I hardly ever use INFORMATION_SCHEMA or have to type in ALTER PROCEDURE so the work around for these specific cases was to modify the snippet. However, I think that if the suggestion window is present and you have an item selected in it that selection should take precedence over any snippets.
  
  Hope you can look into this issue before the final realease.

  tanya June 11, 2009 12:59

  - 0 +

Add comment

Please sign in to leave a comment.