ScottGu's Blog

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

I've used this - it's purty neat!!

# Red-Gate SQL Query Intellisense Tool (Free Download)

A nice tool by Red-Gate to provide a missing feature from the SQL Server Query Analyzer, which is Intellisense....

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

This is an interesting tool, but people should evaluate it pretty carefully...

It runs as a separate process, since QA doesn't really support a plug-in model. That means it presents an icon in the desktop tray and runs even when QA doesn't.

The first time you connect to a database, you'll need to set up a connection in the Prompt tool. You can set up databases on the same server to use the same credentials if you want, but each time you use a server for the first time you'll get kicked out of QA into the Prompt connection manager to connect.

Finally, it seems a little brittle to me. Changing table or view aliases after resolving the suggestion list the first time seems to confuse the product, and using an alias for a table or view that is the only one included in a query doesn't seem to work all the time.

HOWEVER - it is a great idea, and it is a very useful tool. I also personally recommend Apex SQL Edit - it's a good tool with auto-completion and supports fun things like unit testing, integrated source control and other fun things. Not a commercial endorsement, just an avid fan and user.

# Red-Gate SQL Query Intellisense Tool (Free Download)

Intellisense para el query analizer de sql server... la noticia esta publicada en ScottGu's Blog...

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

I've always been frustrated that when I press Ctrl-Space in SQL Query Analyzer it doesn't do syntax completion like Visual Studio does. Well, now it does...

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

I'm sure the tool is great but thier marketing technique is questionable. The 3 step wizard has a hidden step that requires alot more information then originally presented.

As someone who spend alot of time doing internet marketing, they are basically collecting data for a email marketing list.

The long hidden form is designed to make you bail during the checkout process. In eMarketing each extra step translates directly to people who ditch the pipeline.

The 3 step process is presented to give you the illusion that you will give them your email address and they will give you thier software (presumably in a download link mailed to the email address you submit). The hidden steps asks for loads more information. The email address collection page gives a fake sense of security when they say they won't share your address with 3rd parties. However, they never give you the option to opt-in or opt-out of any marketing campaigns.

I just put my email address in there and bailed on the hidden step. I'll report back to you when the spam starts. They might make great tools, but you have to question thier marketing techniques.

# Red-Gate SQL Query Intellisense Tool - Koster ikke en klejne

http://weblogs.asp.net/scottgu/archive/2006/05/22/Red_2D00_Gate-SQL-Query-Intellisense-Tool-_2800_Free-Download_2900_.aspx...

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

SQL Prompt only work with English language versions of SQL Server

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

Scott, I don't know how to thank you !!!. This is what I was looking for in so many time .... This is just Great. Thanks

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

This tool worked nicely in SQL Server Management Studio, and performed all the tricks shown in that animated gif.  Except one: when I type PRINT @@ I don't get any intellisense.  P.S. I think the objections expressed in a few of the other comments are a bunch of hooey.  I'm definitely going to get benefit from this tool.

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

A great tool!

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

hi scott,
thanks for the link.
the tool works great with sql server management studio.
it definitely is gonna help me for sure.
as for the marketing problem as written above by paul,well i would only say there is no free lunch ! u can always give fake info to register ! ! !

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

Is this tool, used for local databases only or for the databases existing on the servers as well. Because i could not observe the intellisense when i used it on the server.

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

I have tried Prompt Sql 1.2 in the past. It costed USD 25.00 It was a bit flaky. Its SQLPrompt now.
Now I see the same product packaged with Red Gate Logo with a slightly different Options screen. I wonder when Microsoft with release a true intellisense SQL Editor.
Otherwise, its good as long as its free....

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

Yep, it works for remote databases, too. Even worked for me over the internet, no less. You may need to be enable tcpip to the database, or start typing a query and hit ctrl-space. Then you'll get a prompt to log into your remote database.

I thought it was cool how it auto-completed inner joins with the relevant keys/foreign keys.

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

I have been using RedGate SQL tools for about 2 years now and I love them. I found out about this tool in one of their newsletters. The newsletter indicated that it was purchased technology, that RedGate will work over and charge for later. So, don't delay, get it now. As soon as I tried it out, I was hooked. I shared it with everyone in my office and everyone has had nothing but raves so far.  

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

A nice tool to fill the gap between now and the RTM of the LINQ project :)

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

Nice tool

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

I am speechless... this should have been around a long time ago...  Thanks for the link.

# Intellisense for SQL Server editors

http://www.red-gate.com/products/SQL_Prompt/index.htm
Basically, install it, run query analyzer, type...

# Intellisense för SQL-frågor

Scott Guthrie, General Manager för Microsoft Developer Division, tipsar om Red Gates SQLPrompt som ger...

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

Hi there,

A comment above states that SQL-Prompt will only work in English versions of the Query Analizer only. Is that True? I tried it in my Spanish QA and it's not working.

Thanks you

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

BTW, SQL Prompt version 2 was free, new version 3 cost $195 per license.

Thank you

# re: Red-Gate SQL Query Intellisense Tool (Free Download)

Does anybody have the Version 2. Can anyone share it please. I had it on my disk and my partitions got messed-up. so dont have the HDD anymore.

appreciate if anyone can help on this.

# SQL Server JOIN conditions

SQL Server JOIN conditions

# sql free download

Pingback from  sql free download

# fgdg

You've been kicked (a good thing) - Trackback from DotNetKicks.com