Viewing 15 posts - 6,016 through 6,030 (of 7,636 total)
netpicker9 (7/31/2008)
I was asking is there anything like oracle has..
I want to write my all procedures, functions in one file (package in oracle).. and I want to call that...
August 7, 2008 at 8:26 am
GilaMonster (8/7/2008)
rbarryyoung (8/6/2008)
August 7, 2008 at 8:13 am
Marek Skotnica (8/7/2008)
-- insert into SOURCE
select [Name], Age, case(Sex) when 'M' then 'm' else 'f' end
from (
select...
August 7, 2008 at 8:11 am
Sorin Petcu (8/7/2008)
in BOL it says that SQRT ( float_expression )
and float could be, as definition of float,
float - 1.79E+308 to -2.23E-308, 0 and 2.23E-308 to...
August 7, 2008 at 7:58 am
skyline666 (8/7/2008)
Got it right :cool:. Out of interest, what was the "@b bigint" for, to try and confuse people with the @b-17 answer :D?
Actually, if was to give versimilitude...
August 7, 2008 at 7:45 am
Christian Buettner (8/7/2008)
What a nasty question... 😛Is this standard SQL behaviour or just MS style?
Standard ANSI SQL. The key is that "^" is NOT the exponent operator as many...
August 7, 2008 at 7:34 am
hodgy (8/7/2008)
Oh, I fell for that one. good question, highlighting an incorrect assumption of mine (I neither use exponents nor bitwise XORs on a regular basis).Thanks, Tom
Thanks Tom. ...
August 7, 2008 at 7:28 am
DDL statements do not usually accept a Database name.
August 6, 2008 at 9:39 pm
Then can you provide the run-time statisitics?
August 6, 2008 at 4:18 pm
c.holman (8/6/2008)
Thanks for the Response.I was reading that perhaps creating a UDF (User Defined Function) to process the String would be faster, or perhaps a CLR assembly?
No and no....
August 6, 2008 at 3:45 pm
It's not clear what you mean (ie., what distinction you are drawing). Please provide some examples.
August 6, 2008 at 3:38 pm
Your query will only modify those records where:
WHERE pp.Reference = m.OldRef
the other records will be untouched.
August 6, 2008 at 3:34 pm
First, when mixing ANDs with ORs, I strongly recommend using parenthesis to explicitly specify the order of operations.
August 6, 2008 at 3:29 pm
Heh. I just finished the RC0 download. Oh well, starting again...
August 6, 2008 at 2:43 pm
Viewing 15 posts - 6,016 through 6,030 (of 7,636 total)