Viewing 15 posts - 106 through 120 (of 129 total)
I feel disgusting, flogging such a long-dead horse, but I can't resist:
Mode 90 SQL2005 implements SQL correctly therfore the correct answer is (d)!
The accuracy of the answer does not depend...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
April 1, 2008 at 5:11 am
This is actually much cooler than it looks - a poster above noted this but I did not understand until I tested...
If you specify a column alias that matches...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
March 31, 2008 at 10:35 am
For SQL Server 2000, none of the answers are quite correct, because the closest answer (A) misses the fact that the column is not just at the start, but also...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
March 31, 2008 at 4:09 am
Thanks GSquared - this makes sense to me.
I don't think I agree about the clarity of using CTEs for derived tables, but I guess that might be because I...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
March 18, 2008 at 8:18 am
I see the value of CTEs, but I'm not sure I agree with the example... wouldn't it be better written (more efficient?) using a single aggregate query and a TOP...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
March 18, 2008 at 2:32 am
the question could possibly be more interesting (at least to some readers) if the result of the division was not so obviously an integer, eg:
select 25 / 6 + 6...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
March 17, 2008 at 3:02 am
This is a brilliant concept, and I'm amazed I have not seen it anywhere else!
There are some known issues with full-text search:
- when searching, you need to look for...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
February 21, 2008 at 6:01 am
incidentally, not having the sponsored book, I was using this as reference:
http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx#EXIAG
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
June 28, 2007 at 2:52 am
OK, I'm a little confused... does an "IN" clause with only a single argument not count as an "IN" clause for the purposes of auto-parameterization? I got the answer right...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
June 28, 2007 at 2:51 am
The "Right" answer is apparently a little misleading here... According to BOL, there would be entries in the DMV, they would just have all counters set to 0.
http://msdn2.microsoft.com/en-us/library/ms188755.aspx
Effectively, this...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
May 7, 2007 at 12:22 am
Hi,
I'm a latecomer to the party and didn't realize there had already been healthy debate, but here's what I came up with.
Looking through the previous submissions above, it's the same...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
April 3, 2007 at 2:59 am
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
June 12, 2006 at 7:17 am
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
May 24, 2006 at 7:20 am
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
May 23, 2006 at 7:10 am
Not just you.
As far as I can tell, the "Question of the Day" has gone all to pot in the last week or two. I'm giving it a break...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
May 2, 2006 at 7:34 am
Viewing 15 posts - 106 through 120 (of 129 total)