How I Got SQL Intellisense Working in Microsoft Query Analyzer

Thanks to everyone who submitted a video for the first-ever Show Off event at PDC05. We had 25 submissions in the space of just a few weeks. To view all of the submissions, look for videos tagged with showoff.

How I Got SQL Intellisense Working in Microsoft Query Analyzer
Atadore

Length: 4:14
Shown at PDC05: Yes

The video explains how I got Intellisense to work inside Microsoft's Query Analyzer by writing a program that uses low level system hooks and the ANTLR parser to intercept Ctrl-Space parse what has been typed in, and use system tables to show Intellisense-style popups inside the standard Query Analyzer.

Credits

• Damian Mehers

Tools used

• C#
• Visual Studio.NET
• SQL Server

Contacts

• http://www.promptsql.com/feedback.html