---
title: "SqlAssist is to VS SQL text as CodeSmart is to VB 6 code - Wonderful"
url: "https://osherove.com/blog/2006/2/6/sqlassist-is-to-vs-sql-text-as-codesmart-is-to-vb-6-code-won.md"
canonical: "https://osherove.com/blog/2006/2/6/sqlassist-is-to-vs-sql-text-as-codesmart-is-to-vb-6-code-won.html"
published: "2006-02-06T22:59:00"
updated: "2006-02-06T22:59:00"
tags: ["Cool Tools"]
author: "Roy Osherove"
description: "Wow, what a cool addin for VS 2005 to add Intellisense to your SQL queries! Check out SqlAssist [via Hannes ] Best of all - it's in beta testing and is free to download! some of the coolest features: Intellisense for…"
usage: "Licensed under CC BY 4.0 — reuse, quote and adapt with attribution (Roy Osherove, link to the original page)."
license: "https://creativecommons.org/licenses/by/4.0/"
---

# SqlAssist is to VS SQL text as CodeSmart is to VB 6 code - Wonderful

By Roy Osherove February 6, 2006 In [Cool Tools](https://osherove.com/blog/category/cool-tools)

**Historical article** · Originally published February 6, 2006; technical details may be outdated.

Wow, what a cool addin for VS 2005 to add Intellisense to your SQL queries!

Check out [SqlAssist](http://www.roundpolygons.com/Home/tabid/89/Default.aspx) \[via [Hannes](http://weblogs.asp.net/HPreishuber/archive/2006/02/06/437542.aspx)\]

Best of all - it's in beta testing and is free to download!

some of the coolest features:

- Intellisense for tables, columns  and variables. works on temp tables and aliases just as well
- Code formatting with changeable rules
- Templates (like snippets) of SQL code with shortcut macros
- Char completion - automatically closes '(', single quotes etc. even on selected text
- Has an object explorer just like the SQL analyzer you know and love, complete with "Script to" ability.
- Works in VS 2003 and VS 2005

## More in Cool Tools

[All posts in Cool Tools](https://osherove.com/blog/category/cool-tools)

- Apr 2, 2006

    ### ["Cool Commands" for VS 2005 is a free and useful little Add-in!](https://osherove.com/blog/2006/4/2/quotcool-commandsquot-for-vs-2005-is-a-free-and-useful-littl.html)

- Feb 16, 2006

    ### [KeePass + FolderShare = Store your passwords securely and share them at the same time](https://osherove.com/blog/2006/2/16/keepass-foldershare-store-your-passwords-securely-and-share.html)

- Feb 6, 2006

    ### [Need an online version of Word or Excel? Try Writely and iRows.](https://osherove.com/blog/2006/2/6/need-an-online-version-of-word-or-excel-try-writely-and-irow.html)

- Feb 4, 2006

    ### [Amazoner and iTunes](https://osherove.com/blog/2006/2/4/amazoner-and-itunes.html)


---

## About the author

**Roy Osherove**: Senior Solutions Architect at AWS working on AI for production and AI-driven development; author of The Art of Unit Testing and Elastic Leadership, with about 20 years of consulting and training on unit testing, TDD, team leadership and continuous delivery.

### Sites

- [RobotPaper](https://robotpaper.ai/): This blog: AI patterns and anti-patterns, AI and coding agents, and engineering leadership.
- [osherove.com](https://osherove.com): Roy's personal site. Author of The Art of Unit Testing and Elastic Leadership; consulting and training on unit testing, TDD, team leadership and continuous delivery, plus about 20 years of blog posts.
- [The Art of Unit Testing](https://www.artofunittesting.com): The Art of Unit Testing, 3rd Edition (Manning): readable, maintainable, trustworthy unit tests, plus TDD workshops in C#, JavaScript, Java and Kotlin.
- [5whys.com](https://www.5whys.com): Roy's writing on software team leadership: self-organizing teams, surviving chaos, learning mode and the Elastic Leadership model.
- [Pipeline Driven](https://pipelinedriven.org): Continuous delivery and DevOps practices: build patterns, pipeline-friendly testing, DevOps metrics and enterprise DevOps.
- [Elastic Leadership](https://www.elasticleadership.com): Elastic Leadership, Roy's framework for software team leaders (survival, learning and self-organizing modes).

### Social

- X: https://x.com/royosherove
- LinkedIn: https://www.linkedin.com/in/osherove/

### Contact

- Contact form: https://forms.gle/jQSx5KoXvrVA1JCK7

### License

Licensed under CC BY 4.0 — reuse, quote and adapt with attribution (Roy Osherove, link to the original page). License: https://creativecommons.org/licenses/by/4.0/