My question is given I have a schema named tmp why would I want to create a table named like that in the real world, other than to prove a...

As I tell my beginning programming students, radio buttons for single answers, check boxes are for multiple responses. Although with some effort you can isolate radio buttons to allow multiple...

I'm not sure that the case sensitive had any place other than to potentially mislead. The result, given the data, is the same so CI vs CS if Carl had...

The problem is the missing answer #4: All of the above.

Because:

1. the query returns "0 rows" of data

2. because ShowPlan is on the Select statement does not execute

3. SQL Server...

Good question, learned something new today.

Thanks,

Lon

Great question, another correction to allow it to work is changing "= 1" to "> 0", obviously without the quotes included.

Thanks,

Lon

Good question!

Thanks,

Lon

Changing the where to and will result in the same output from both of the queries.

Good question, but I agree that SQL is not easy when it comes to the use of the semi-colon, compared to C#.

Thanks,

Lon

Good question, this is truly an infinite loop, only the limitation of the platform prevents this executing an infinite number of times. If SQL server in some future version were...

Thanks, for the reminder about the Choose function. The beauty is the ability to provide two things, an alternate name or identification as well as a different sort order...

Regardless, Happy New Year to all.

Good question, learned something today. Didn't think a numeric related setting would effect an action relating to textual information, oh well.

Thanks,

Lon

Good question if only I had read the "not", oh well.

Thanks,

Lon

Not a lucky guess, but a good question none the less. After reviewing the answer and explanation, I learned something, probably nothing I can use today, but who knows where...