Viewing 15 posts - 1,981 through 1,995 (of 7,484 total)
Quite a nice question, but I agree with Hugo about the explanation.
An interesting point is that what the queries return depends on options. If ANSI_DEFAULTS is off, both will...
January 23, 2015 at 11:52 am
This is a nice question. But it needed Hugo's explanation.
Actually it's a very a good question to raise, because maybe it will counteract some of the misleading QotD explanations...
January 23, 2015 at 11:15 am
I don't really care whether it's Id or ID or id, but use Id usually. Of course if I'm in a database where every column name is upper...
January 21, 2015 at 5:48 pm
Brandie Tarvin (1/21/2015)
Sioban Krzywicki (1/21/2015)
January 21, 2015 at 5:11 pm
Sioban Krzywicki (1/21/2015)
January 21, 2015 at 4:39 pm
g.britton (1/21/2015)
Just though I'd dispel the notion that only count(*) counts nulls:
select count('null') as count_null from (select null n union all select null) countnull
returns:
count_null
2
We can have even more fun:
with thing(I)...
January 21, 2015 at 4:08 pm
Carlo Romagnano (1/19/2015)
TomThomson (1/19/2015)
But I don't like the last sentence of the explanation
Transaction started by "BEGIN TRAN" may end prematurely and unexpected by some errors that may...
January 19, 2015 at 9:28 am
Ed Wagner (1/19/2015)
SQLRNNR (1/19/2015)
Ed Wagner (1/19/2015)
djj (1/19/2015)
Ed Wagner (1/16/2015)
whereisSQL? (1/16/2015)
Ed Wagner (1/16/2015)
crookj (1/16/2015)
Ed Wagner (1/16/2015)
djj (1/16/2015)
Ed Wagner (1/16/2015)
TomThomson (1/16/2015)
SQLRNNR (1/16/2015)
divisionmultiplication
addition
subtraction
Exponent
Percent
Discount
Sale
Volume
Sound
Wave
Blaster
Master
Slave
January 19, 2015 at 8:58 am
Nice question.
But I don't like the last sentence of the explanation
Transaction started by "BEGIN TRAN" may end prematurely and unexpected by some errors that may ROLLBACK transaction.
That...
January 19, 2015 at 8:47 am
Andre Ranieri (1/16/2015)
Thanks for the great question - I learned something here.Wouldn't this solution involve droppping and re creating the check constraint ever day to maintain workability?
Andre Ranieri
No. Once...
January 16, 2015 at 6:53 pm
Sean Lange (1/16/2015)
TomThomson (1/15/2015)
Sean Lange (1/14/2015)
Koen Verbeeck (1/14/2015)
I might need...
January 16, 2015 at 10:16 am
Koen Verbeeck (1/14/2015)
Steve Jones - SSC Editor (1/14/2015)
Boy, it seems like my questions are getting worse lately. Taking a beating in the QoD.
The question of today wasn't bad at...
January 16, 2015 at 9:46 am
Nice question.
ssimmons 2102 (1/16/2015)
isn't only 15k on 64-bit and 1k on 32-bit?
How many partitions it allows us to create on the 32-bit version isn't documented anywhere as far as I...
January 16, 2015 at 9:30 am
Sean Lange (1/14/2015)
Koen Verbeeck (1/14/2015)
Nope, I'm control freak enough to change it to SELECT 1. I even do it in the scripts generated by SSMS.I might need some help...
If we...
January 15, 2015 at 4:54 pm
Viewing 15 posts - 1,981 through 1,995 (of 7,484 total)