Viewing 15 posts - 1 through 15 (of 58 total)
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...
April 8, 2015 at 11:42 am
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...
August 8, 2014 at 8:28 am
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...
June 27, 2013 at 7:54 am
The problem is the missing answer #4: All of the above.
1. the query returns "0 rows" of data
2. because ShowPlan is on the Select statement does not execute
3. SQL Server...
June 13, 2013 at 8:03 am
Good question, learned something new today.
April 30, 2013 at 8:12 am
Great question, another correction to allow it to work is changing "= 1" to "> 0", obviously without the quotes included.
April 25, 2013 at 8:21 am
April 19, 2013 at 7:29 am
Changing the where to and will result in the same output from both of the queries.
April 4, 2013 at 7:55 am
Good question, but I agree that SQL is not easy when it comes to the use of the semi-colon, compared to C#.
April 2, 2013 at 7:53 am
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...
March 1, 2013 at 7:33 am
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...
January 14, 2013 at 8:33 am
Regardless, Happy New Year to all.
January 1, 2013 at 8:44 am
Good question, learned something today. Didn't think a numeric related setting would effect an action relating to textual information, oh well.
December 14, 2012 at 9:13 am
Good question if only I had read the "not", oh well.
December 3, 2012 at 7:53 am
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...
December 3, 2012 at 7:37 am