I do bitwise operations fairly often, yet was thrown off at first by the & operator. My probelm is I'm also a VB programmer where it is used for string...

I'm pretty sure you could avoid the VBA altogether if you replace the Stored Procedure with a parameterized table-valued User Defined Function.

Nice question. Hopefully I'll trip over this one enough times to prevent me from making that mistake when it counts.

Thanks,

The question is specifically referring to SQL Server indexes. The Microsoft definition would make the...

I agree with Tao that thoughtful aliasing, as opposed to A. B, C, will make code easier to read for the programmer, debugger, or DBA. Most who have been around...

I think you meant to say updationing.

I think I get it now. Both answers are correct if we assume that the value of the most recent usage of the timestamp...

Steve is correct to award points. While testing the script indicates only answer #3 is correct. it's possible to find Microsoft documentation supporting answer 2 and also supporting answer 3.

The...

I thought it was going to be a dull day.

Thanks,

I had the correct answer selected, then looked it over 1 last time and saw the tags. I changed my answer and promptly got it wrong. To be fair though,...

Toreador (6/16/2009)

I assume you've never been through the process of converting a large database from varchar/char/text columns to...

Maybe it's because I'm European, but I'm afraid I don't understand the (many) respondents who claim that if the character type is unknown, you should choose the most limited option?...

Hugo,

Never have I learned so much from a single dimwitted attempt at humor. Thanks for the info. I wish I could find the humility emoticons.:blush:

The correct answer for ME is char(1). I work in the U.S. and don't design for international unless it is in the specs.

🙂Hugo - How do you store a NULL?🙂

It's no longer undocumented.:cool: