Viewing 15 posts - 3,181 through 3,195 (of 7,484 total)
ChrisM@Work (8/30/2013)
jasona.work (8/30/2013)
Daniel Bowlin (8/30/2013)
sing4you (8/29/2013)
Jersey BoyThe Boss
Springsteen
Sprightly
Sprite
August 30, 2013 at 8:37 am
An nice amusing question that demonstrates an unfortunate feature of SQL - using contractions is not a habit I would like to get into. so a good question about...
August 30, 2013 at 5:12 am
Sean Smith-776614 (8/29/2013)
August 30, 2013 at 4:58 am
Thorkil Johansen (8/29/2013)
select ISNULL(TRY_CONVERT(INT,SUBSTRING('Ejerskifte-45\Behandlet-45',
NULLIF(PATINDEX('%-[0-9]%','Ejerskifte-45\Behandlet-45'),0)
+ 1,LEN('Ejerskifte-45\Behandlet-45')) ),-1)
I get -1 I would like it to be 45
The problem is that trying to convert the 26 character string '45\Behandlet-45'...
August 29, 2013 at 7:31 am
Ed Wagner (8/29/2013)
August 29, 2013 at 6:55 am
Good question.
Just to amplify what Hugo said, the wording in BOL (which is also in the explanation) is somewhat misleading. Hugo's statement that the tie break between upper and...
August 29, 2013 at 6:37 am
It's a great pity that we will always have bigots amongst us because humanity is not perfect; but that's how it is. I wish I had been there to...
August 28, 2013 at 12:14 pm
Stefan's version caters for retakes too, because it looks for the absence of success rather than the presence of failure - a nice and tidy way to handle retakes.
August 28, 2013 at 11:11 am
Craig-315134 (8/27/2013)
Grand Fenwick...
August 27, 2013 at 4:00 pm
PHYData DBA (8/27/2013)
If updating a row does not affect other records (though it affects secondary indexes) the table is a heap.
Very short exact and clear.
This might...
August 27, 2013 at 3:41 pm
Steve Jones - SSC Editor (8/27/2013)[hrThe idea isn't just to have them attack a fake system, but also to learn about how they attack (and from where). The honeypots can...
August 27, 2013 at 12:26 pm
GilaMonster (8/27/2013)
Jason.Reeves (8/27/2013)
August 27, 2013 at 12:03 pm
sqlnaive (8/27/2013)
GilaMonster (8/27/2013)
sqlnaive (8/27/2013)
"DELETE is a logged operation while TRUNCATE is not" as the truncate just deallocates the data pages from the table and...
August 27, 2013 at 11:08 am
Viewing 15 posts - 3,181 through 3,195 (of 7,484 total)