blogs.conchango.com

Crikey.  That title sounds like an essay I had to write when I was at school and that was a long time ago... Jamie Thomson raised an important point in a comment on a blog I posted yesterday entitled "Getting rid of getdate()".  In it I stated that ISNULL() and COALESCE() are in the same boat as getdate() and ...

Ok I admit - I use it. Pretty much everyone I know uses it and yet I feel dirty when I do.  Why? Well it's not portable SQL and most certainly not ANSI standard.  I need to get the datetime I hear you say.  How do I do this without getdate()?  There is a perfectly good substitute in the form of CURRENT_TIMESTAMP that is ...

A colleague of mine asked for a simple example to get him up and running with the basics of bitmasking.  Since I had gone to the effort to create the example I thought I might as well blog it :o). This example uses the logical AND operator &. First of all you need to define your table.. create table BitmaskDemo (ID int Primary ...