Why use strings when you can use char[50000], after all they are the same right?
Best posts made by Sels
-
RE: WTF Bites
-
SQL Date functions are hard
"So I'll just make a table" -My predecesor at this company in 2004
Im just glad its a table and not a view consisting of 1440 selects and unions
-
RE: TDWTF Plays Zork I
@Maciejasjmj said in TDWTF Plays Zork I:
Have fun getting the hell out of here. The current part is the bottom-most one.
Well, I got into hell
-
RE: SQL Date functions are hard
@accalia said in SQL Date functions are hard:
@djls45 said in SQL Date functions are hard:
What is the datatype for the column?
almost certainly
CHAR(12)
I would have expected that too, but its
time
@djls45 said in SQL Date functions are hard:
What sorting method is it using? RTL string sorting?
most likely.... row order which would be more or less order of insertion in most collations, assuming no indexing
Correct, no index, no keys, no nothing else but a table generated from 1440 inserts in a script.
A far as I could find, this is only used to generate a report of the application usage, using this query:
select date_, hd.hora, count(*) as q
from users_logins h
join hora_dia hd
on hd.hora between convert(time,convert(char(8),h.hora)) and convert(Time,GetDate())
where hd.hora between convert(time,convert(char(8),h.hora)) and convert(Time,GetDate())
group by fecha, hd.horaGuess he wanted to discard 4-dimensional users using the software outside time?
-
RE: Citisnoofle
@Scarlet_Manuka said in Citisnoofle:
@Sels said in Citisnoofle:
same difference
I think you'll find you're not sorting 90 before 89 any more, which your original did (because it wasn't actually sorting at all).
I think you'll find there is no 89 selected there
And if there were:
@dkf said in Citisnoofle:
@JazzyJosh said in Citisnoofle:
And AFAIK Chase still toUpperCase's your password before saving it to the database or checking it against your password hash, so your password is case-insensitive.
I'm surprised that they aren't just running all their operations on a database that only supports capital letters and using some skanky code to recreate the lower case letters on output for these newfangled ASCII computers.
Every financial institution I've worked for has had a hard on for capital letters everywhere, I blame accountants.
Latest posts made by Sels
-
RE: SQL Date functions are hard
@accalia said in SQL Date functions are hard:
@djls45 said in SQL Date functions are hard:
What is the datatype for the column?
almost certainly
CHAR(12)
I would have expected that too, but its
time
@djls45 said in SQL Date functions are hard:
What sorting method is it using? RTL string sorting?
most likely.... row order which would be more or less order of insertion in most collations, assuming no indexing
Correct, no index, no keys, no nothing else but a table generated from 1440 inserts in a script.
A far as I could find, this is only used to generate a report of the application usage, using this query:
select date_, hd.hora, count(*) as q
from users_logins h
join hora_dia hd
on hd.hora between convert(time,convert(char(8),h.hora)) and convert(Time,GetDate())
where hd.hora between convert(time,convert(char(8),h.hora)) and convert(Time,GetDate())
group by fecha, hd.horaGuess he wanted to discard 4-dimensional users using the software outside time?
-
SQL Date functions are hard
"So I'll just make a table" -My predecesor at this company in 2004
Im just glad its a table and not a view consisting of 1440 selects and unions
-
RE: Magic: The Gathering thread
@Maciejasjmj and then they go and make Gisela mythic and Bruna rare
-
RE: Magic: The Gathering thread
@DoctorJones said in Magic: The Gathering thread:
I used to love Magic so much, but Wizards have such a heavy focus on the tournament scene, they don't seem to care enough about casual play.
Its wierd reading that, as I and almost every competitive/semi-competitive player I know personally feels the oposite, that wizards is going overboard catering to casual players down-powering standard into a sorceries-and-creatures-only-slugfest and wasting resources in stuff like Commander, conspiracy, making 2HG prereleases and such other kitchen table-y efforts.
-
RE: WTF Bites
Why use strings when you can use char[50000], after all they are the same right? -
RE: TDWTF Plays Zork I
@Maciejasjmj said in TDWTF Plays Zork I:
Have fun getting the hell out of here. The current part is the bottom-most one.
Well, I got into hell