| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> ken- : no - drop the fk, or trunc the other table first
<1> lol.. i sit here wondering for a split sec. how you now my name is ken
<2> phargle
<2> cause he banger ur wife barbie
<1> she's just a friend
<3> yuppie: i did trunc the other table first
<4> does sql server have the ability to manipulate and work with dates, using a timezone modifier ...
<4> i have fields populate in the database, generated by a scheduling system written in T-SQL ... but I'd like the ability to say ... "Run every thursday at 4pm EST" ... rather then just "4pm" ...
<5> why does substring('1234', 0, 4) return '123'
<5> if i start at index 0 and return 4 chars, then i should get '1234' right?
<4> so I can set a timezone value for a schedule, and get the appropriate datetime value back for the servers timezone to be equivalent to the p***ed timezone value ... "4pm EST" would be equal to like "2pm MST/AZ" for example
<4> tenfour it's 1 based ... not 0 based
<4> index 1 is char 1 ...
<4> read the docs ...
<5> ah
<5> thanks
<4> substring("12345", 1, 4) returns "1234"
<4> 0 should cause substring to fail or error
<5> nah it just returns '123'
<5> hehe
<4> :)
<6> hi, I'm using mysql. How do I use a select inside a select? I'm tring to do something like this: SELECT.... WHERE Utgave=(SELECT IDutgave FROM utgave ORDER BY IDutgave DESC LIMIT 1)
<6> I guess that the sql would be the same in any other databases too
<0> SPRT|1| : you'd guess wrong
<0> SPRT|1| : read the topic and the rules
<6> as you saw in my second msg to the channel, I've read them
<6> but your first answer says that the sql would be different from db's to db's
<6> so thank you
Return to
#sql
or
Go to some related
logs:
#computers
jinit11813
#politics
#beginner
mrhands.wmv
#politics
#nhl
#politics
frickadelle
#politics
|
|