in

Hydrus Software Forums

Discussions about Hydrus Software Products
All Tags » SQL (RSS)

Browse by Tags

  • SQL Trick: Finding Integers in Character Columns

    Q: What WHERE condition do you use to find all values in a column that contain only numbers? (No decimal points, no minus signs, just 0-9. A: [ column name ] NOT LIKE '%[^0-9]%' This is the kind of thing that I'll forget a year from now when I need it again. UPDATE: 7/11/06 I ran into the...
    Posted to John's Brain Dump (Weblog) by John on 05-26-2006

  • Free Intellisense for SQL Server!

    I read this morning that Red Gate Software has released a *free* program that adds Intellisense to your standard SQL editors (Query Analyzer, Enterprise Manager, Management Studio and VS). I tried it out, and had it up and running in less than five minutes. Since I write a lot of queries everyday, and...
    Posted to John's Brain Dump (Weblog) by John on 05-22-2006

  • Moving SQL Server Objects

    Well, I'm preparing for a significant move to production tomorrow morning, including a bunch of new database code. I really can't remember how I was confident that I moved everything before I discovered Red Gate's SQL Compare and SQL Data Compare . These tools make database migration a breeze...
    Posted to John's Brain Dump (Weblog) by John on 11-30-2005

  • 5 Reasons to use Indexed Views

    I love indexed views in SQL Server! My current project is a fairly large system for a government entity, containing over 70 live tables, and so the queries that I have written are intense. Many of them are so intense, in fact, that the database server's processor has decided to take its sweet old...
    Posted to John's Brain Dump (Weblog) by John on 11-23-2005

  • Avoiding Cursors with Superclass-Subclass Tables

    Ever since I read Itzik Ben-Gan's article in SQL Server Magazine about changing cursor-based logic to set-based logic, I've avidly sought to avoiding using cursors in my SQL procedures. One of the biggest problems that I've faced on this front is the issue of inserting records into a superclass...
    Posted to John's Brain Dump (Weblog) by John on 11-21-2005
Page 1 of 1 (5 items)
Copyright Hydrus Software, 2007. All rights reserved.