---
title: "Small but useful SQL tips from SQLJunkies"
url: "https://osherove.com/blog/2004/12/7/small-but-useful-sql-tips-from-sqljunkies.md"
canonical: "https://osherove.com/blog/2004/12/7/small-but-useful-sql-tips-from-sqljunkies.html"
published: "2004-12-07T01:11:00"
updated: "2004-12-07T01:11:00"
tags: [".Net Quotations", "Tips & Tricks"]
author: "Roy Osherove"
description: "Here's a nice set of small but might-be-useful-someday SQL tips [via Bersileus ]"
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/"
---

# Small but useful SQL tips from SQLJunkies

By Roy Osherove December 7, 2004 In [.Net Quotations](https://osherove.com/blog/category/net-quotations), [Tips & Tricks](https://osherove.com/blog/category/tips-tricks)

**Historical article** · Originally published December 7, 2004; technical details may be outdated.

[Here's a nice set of small but might-be-useful-someday SQL tips](http://sqljunkies.com/WebLog/xienzyrus/archive/2004/12/06/5390.aspx)

_\[via_ [_Bersileus_](http://sqljunkies.com/WebLog/xienzyrus/archive/2004/12/06/5390.aspx)_\]_

## More in .Net Quotations

[All posts in .Net Quotations](https://osherove.com/blog/category/net-quotations)

- Jan 6, 2005

    ### [Some news from the wild](https://osherove.com/blog/2005/1/6/some-news-from-the-wild.html)

- Jan 3, 2005

    ### [\[WebCast\] The Elixir and Alchemy projects - Outlook Integration with Siebel at Microsoft](https://osherove.com/blog/2005/1/3/webcast-the-elixir-and-alchemy-projects-outlook-integration.html)

- Nov 29, 2004

    ### [TestDriven.Net version 1.0 is out (with a new site design as well)](https://osherove.com/blog/2004/11/29/testdrivennet-version-10-is-out-with-a-new-site-design-as-we.html)

- Nov 7, 2004

    ### [Mitigating malicious plug-ins in your application](https://osherove.com/blog/2004/11/7/mitigating-malicious-plug-ins-in-your-application.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/