SQLServerCentral / Discuss Content Posted by Brian Kelley / Article Discussions / Article Discussions by Author / PromptSQL / Latest Posts

RE: PromptSQL

K. Brian Kelley — Wed, 25 Jan 2006 14:23:00 GMT

Sweet. I'll have to mark down the forums.

RE: PromptSQL

Damian Mehers — Wed, 25 Jan 2006 13:39:00 GMT

Pete, I only activated forums on the PromptSQL web site at the beginning of the week -- so you didn't miss them :-)FWIW if anyone wants to be notified by email/rss of new PromptSQL releases, then I recommend signing up for notifications on the "PromptSQL Release History" forum.The forums are at: http://promptsql.com/community/forums/Regards, Damian

RE: PromptSQL

K. Brian Kelley — Wed, 25 Jan 2006 13:12:00 GMT

Well, the comments on the review has kind of turned into the forum for it.

RE: PromptSQL

Peter Schott — Wed, 25 Jan 2006 11:23:00 GMT

There's a forum? I've completely missed that. This is a really useful product for the cost. One of the few things that I've actually bought right away. Looking forward to the next release as it should address some minor annoyances I have right now.-Pete

RE: PromptSQL

K. Brian Kelley — Wed, 25 Jan 2006 07:02:00 GMT

Good point, I did. The snippets can come in very handy, I just haven't retrained my self to use them. By the time I think "SELECT * FROM" I have already typed it.

RE: PromptSQL

David.Poole — Wed, 25 Jan 2006 01:54:00 GMT

Brian,You forgot to mention the snippets!type in ssf and press TAB and you get SELECT * FROM.You can add your own as well so I have set upderr to bring up DECLARE @lError INT , @lRowCount = @@ROWCOUNTserr to bring up SELECT @lError = @@ERROR , @lRowCount = @@ROWCOUNTThere are some basic issues with this product but looking at their forum it looks like they are actively addressing these issues.Lets face it US$25 is not a lot of money. It's the price of a CD in the UK

RE: PromptSQL

Damian Mehers — Fri, 20 Jan 2006 09:01:00 GMT

Hello there,Could you verify that your current statement has a blank line in front of it?Instead of:use Northwindselect * from do:use Northwindselect * from If that isn't it, please email me the log per my earlier post.Thanks, Damian

RE: PromptSQL

JStiney — Thu, 19 Jan 2006 14:45:00 GMT

I did try unchecking List databases when listing everything, but

that did not work.

RE: PromptSQL

K. Brian Kelley — Thu, 19 Jan 2006 14:34:00 GMT

Bring up your PromptSQL options (double-click on the tray icon is the easiest way). Click on the Content tab and uncheck List databases when listing everything.

RE: PromptSQL

JStiney — Thu, 19 Jan 2006 13:44:00 GMT

I just installed PromptSQL and I'm getting mixed results.

When I 'space' after a verb like from or join, I get a list of databases instead of tables or procedures.

RE: PromptSQL

Damian Mehers — Thu, 19 Jan 2006 01:35:00 GMT

Hello A.J,

The thing gets some people is that (as Brian mentioned in his article) to optimize the parsing, PromptSQL currently only parses the chunk of text around the cursor that is delimited by empty lines. We also don't support functions, and we don't handle subqueries properly. The second two items should be addressed before the end of the month.

I thought it was worth releasing a product that was useful, if not perfect, on the basis that the missing features would be added over time (http://www.promptsql.com/releases.htm)

If you can email me offline, I'd really like to understand what is not working for you, so that other people don't have the same experience.

Thanks,

Damian

RE: PromptSQL

A.J. Wilbur — Wed, 18 Jan 2006 16:14:00 GMT

I downloaded the trial version. Used it for about 5 minutes, before I realized it was worthless due to the lack of quality. Without going into a ton of details, let's just say my opinion is that it's a product that any SQL Developer would just get frustrated with over time. Nice idea, but quality needs improvement, before I'd spend $$ on it.

RE: PromptSQL

Damian Mehers — Wed, 18 Jan 2006 12:02:00 GMT

If you can enable logging (right-click on the PromptSQL icon, click on "View Log...") and send me a log, I'd be happy to take a look at what is happening when it isn't working.You can send it using the feedback form on the web site at: http://www.promptsql.com/feedback.htmlSame goes for anyone else that has any problems or suggestions for PromptSQL -- I want to make it better!Re functions -- they will be supported in the 1.3 release, due out before the end of the month. This is a list of enhancement requests, and features that have been added: http://www.promptsql.com/known_bugs_and_possible_enhancements.htmRegards, Damian (author of PromptSQL)

RE: PromptSQL

Rick Todd — Wed, 18 Jan 2006 10:59:00 GMT

I think this utility is pretty good. I'm going to test it a bit more. We have about 4500 objects (select count(*) from sysobjects where type in ('u', 'p', 'fn', 'v')) that PromptSQL has to sort through, and I think it's bogging it down a little, but it's still slick. My major "con" would be the lack of function support, as mentioned above. I'm submitting that as feedback. I have to admit that I only skimmed the article, and got excited about not having to hit SHIFT-F1 anymore to remember which parameter comes first in LEFT vs. REPLACE, etc. This probably added to my disappointment at lack of function support.I'm still going to buy it, and enjoy it though.

RE: PromptSQL

John Dempsey — Wed, 18 Jan 2006 09:53:00 GMT

P. Barbin - I appreciate the link to SQL Assist but I don't write my DB code (stored procedures) in Visual Studio. I use SQL QA. This is where I need the intellisense .

RE: PromptSQL

Todd H-247318 — Wed, 18 Jan 2006 09:51:00 GMT

Hmmm, Ok. It seems to be back now.

RE: PromptSQL

Todd H-247318 — Wed, 18 Jan 2006 09:49:00 GMT

Sorry,

I was talking about PromptSQL

RE: PromptSQL

K. Brian Kelley — Wed, 18 Jan 2006 09:48:00 GMT

Just hit the site myself, so it's up.

RE: PromptSQL

PaulBarbin — Wed, 18 Jan 2006 09:48:00 GMT

I don't know if you're talking about PromptSQL or SQL Assist, but I noticed that I didn't post the site to SQL Assist. And for some reason, when I google "SQL Assist" it doesn't come up. Its at www.roundpolygons.com.P Barbin

RE: PromptSQL

K. Brian Kelley — Wed, 18 Jan 2006 09:45:00 GMT

In the quick testing I did, no, it doesn't do IntelliSense on the functions from what I saw. However, if you send feedback to the folks at Atadore I'm sure they'll think about including it. They've proven to be extremely responsive in my dealings with them.PromptSQL Feedback Form

RE: PromptSQL

Todd H-247318 — Wed, 18 Jan 2006 09:44:00 GMT

I've been trying to get to their site but it keeps coming up unavailable. Are any of you having that same issue??

RE: PromptSQL

PaulBarbin — Wed, 18 Jan 2006 09:42:00 GMT

It is available in SQL Assist.P Barbin

RE: PromptSQL

John Dempsey — Wed, 18 Jan 2006 09:37:00 GMT

I have been tempted to check this out for some time. I am still considering it and will probably test it out after this review.

I have a question about the Intellisense programs out there, does the Intellisense work with the functions? It really irritates me that SQL Query Analyzer does not provide Intellisense for its functions. I hate have to always go to the BOL to remember what variable is required first in functions (ex. CHARINDEX, PATINDEX, REPLACE, etc.). Does anyone know if that is available?

RE: PromptSQL

Francis Apel — Wed, 18 Jan 2006 09:20:00 GMT

Lets face it. At $25 a pop, you can't go wrong. Even if you use it only minimally. It can pay for itself in as little as 1/2 hour of time savings. There isn't anyone who can say that this won't save them at least 1/2 hour of time throughout the life of the product. I could see a lengthly discussion on this if it were, say $1000, but at $25, it has already taken more of my time to write this reply than to pay for the product. Yes there are better products. No, there are no better products for $25. Its that simple. I bought a copy to use for myself out of my own pocket (I didn't want the hastle of having to explain and have my manager approve a $25 purchase).

RE: PromptSQL

PaulBarbin — Wed, 18 Jan 2006 08:07:00 GMT

I've looked at a number of SQL Intellisense programs and chose "SQL Assist" based on two features - templates and sql formatting. Their Templates are extremely powerful and configurable. SQL formatting is very good and is useful when I post some long query that I get from Profiler.Down side: It runs only on Visual Studio for the moment.P Barbin

RE: PromptSQL

K. Brian Kelley — Wed, 18 Jan 2006 07:03:00 GMT

Instead of posting comments like this, can you explain some of your issues with the product? For folks trying to make a decision on whether or not to plunk down some money, this kind of comment doesn't offer them any additional information one way or the other.

RE: PromptSQL

K. Brian Kelley — Wed, 18 Jan 2006 07:02:00 GMT

Aye, I love Apex SQL's Edit program as well. However, PromptSQL fits a nice niche: want IntelliSense but without the expenditure of cost for another environment? PromptSQL takes care of it. This works out well, too, if you don't want to switch because of personal preference to the Microsoft provided tools. Some people just prefer those tools to any others but would like IntelliSense.

RE: PromptSQL

K. Brian Kelley — Wed, 18 Jan 2006 06:59:00 GMT

You may have to adjust the sensitivity on how quickly it displays. The default setting for the pop-up boxes and tool tips is 400 ms. Some people want it to pop-up immediately and you can do so by reducing the number for the delays.

RE: PromptSQL

Peter Schott — Wed, 18 Jan 2006 06:46:00 GMT

I beta-tested the app and bought it almost as soon as the buy link was available. It worked great for me under Query Analyzer, SSMS beta and SSMS release. I don't use VS much for SQL, so can't really comment on that. I did notice the SQL Login prompt a couple of times, but mostly if I had network trouble (or in one instance had to alias my machine).The programmer was always very quick to respond to my suggestions and requests for help. I'd recommend contacting him with details of your problem if you're having trouble. Be sure to capture a log first - that's not enabled by default.Atadore's running a list of suggestions/bug fixes on his site as well. You can suggest new features or check on the status of existing requests to see if they will be in the next version. He's implemented several of the ideas already. I also find it cool that he's not a SQL Server guy. He's a programmer who saw this opportunity and developed the idea.Only change I'm waiting for now is a minor tweak that will display columns when you expand something in the actual column order. Atadore has a minor bug in 1.2 that sorts columns treating the order as a character instead of an int. He wrote back and explained that it was missed in testing, but fixed for the next release.For the $25 this cost, it was well worth it. Here's hoping that he doesn't get snatched up by some large company that will boost the license cost through the roof. :-)

RE: PromptSQL

N Cook — Wed, 18 Jan 2006 06:45:00 GMT

I couldn't get it to popup consistently. Has anyone that has tried the product with mixed results been able to fix that?

RE: PromptSQL

John Morrelles-204026 — Wed, 18 Jan 2006 06:43:00 GMT

PromptSQL looks like a slick little Intellisense program. For $25, it's a great deal if Intellisense is the *only* feature you're looking for. I have to plug ApexSQL's Edit program, though. It has Intellisense and *so* much more.

RE: PromptSQL

anders berthelsen — Wed, 18 Jan 2006 06:00:00 GMT

Shit doesnt work!!!!!!!!

RE: PromptSQL

Mike Metcalf-160221 — Wed, 18 Jan 2006 03:45:00 GMT

A great article, I was really looking forward to intellisense being available in sql 2005 until they decided to drop it.

I can see this being a useful in our environment and should make my life a little easier

PromptSQL

K. Brian Kelley — Mon, 02 Jan 2006 17:43:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/promptsql.asp