September 2004 - Posts

More T-SQL Weirdness

Published Mon, Sep 13 2004 21:09 | GregLow

Erland Sommarskog pointed the following out to me: SELECT 5ee I wouldn't have thought that was at all valid. I found heaps more like: SELECT 0xBEG SELECT 0xFEZ SELECT 5.G SELECT 0xET (phone home) Interesting parsing. I would have just dismissed these...

T-SQL Binary Weirdness

Published Mon, Sep 13 2004 17:23 | GregLow

It's always a good day when you learn something new. Steve Kass taught me something new about T-SQL today. If you execute the following: SELECT 2 + 3 the value returned is 5. However, if you execute: SELECT 0x2 + 0x3 the value returned is 0x0203. Am I...

A Design Pattern For Nested Triggers?

Published Mon, Sep 6 2004 11:23 | GregLow

Ever since sql server 2000 appeared, we've had the ability to create multiple triggers on a single table. Until a problem I saw at a site the other day though, I'd never REALLY stopped and thought about the consequences of using multiple update triggers...