Viewing 13 posts - 1 through 13 (of 13 total)
SQL Kiwi (1/5/2012)
Interesting. The documentation looks very similar between ASE 15 and SQL Server:
http://msdn.microsoft.com/en-us/library/ms190476.aspx
The magic number 6 appears for division in both, but not multiplication.
Interesting find ... however...
January 5, 2012 at 6:05 pm
SQL Kiwi (1/4/2012)
My prior post was written before I saw your latest, so it wasn't aimed at the points you raised. I'm going to decline getting into a debate...
January 5, 2012 at 12:44 am
SQL Kiwi (1/4/2012)
There are many quirks to SQL Server
A bad thing tm!
SQL Kiwi (1/4/2012)
The point of this QotD is very much to emphasise that using excessive precision or scale can...
January 4, 2012 at 9:43 pm
Just to jazz things up ... I have refactored the code to make it work on another SQL dialect as follows ...
DECLARE @n1 DECIMAL(38,20)
, ...
January 4, 2012 at 7:44 pm
Toreador (1/4/2012)
... It baffled me when I first came across it, and it baffles me still.
I put it down to expediency prevailing over sensibility.
It was seen as too hard to...
January 4, 2012 at 6:59 pm
How weird stuff like this survives in a commercial offering beggars belief (well mine if no-one elses)!
My implicit expectation - formed in earlier days (aka Fortran IV and CDC ASM...
January 4, 2012 at 5:25 am
Ken Lee-263418 (1/1/2012)
January 3, 2012 at 4:55 am
Also well said Old Hand.
One of the conundrums I often observe in the hobbyist intellectual is that even after the first sign of dark clouds on the horizon they don't...
January 1, 2012 at 5:03 pm
I agree the existence of this management behaviour! However (IMO) the very holding of this belief is feeble in the extreme ... and is a clear marker for a...
April 30, 2011 at 10:08 pm
Original post mashed the code frag...
Frank Hamersley (12/8/2008)
... if it isn't why not simply fix the dynamic sql to look like (after creating the CustomerMaster table) ....
IF Exists(SELECT Customer FROM...
December 9, 2008 at 5:06 am
henrik staun poulsen (12/9/2008)
Well, I've seen worse; like the programmer that loved to write "BEGIN TRAN", but forgot a few "COMMIT" or "ROLLBACK".
And this system actually works, and makes...
December 9, 2008 at 5:05 am
This has got to be a wind up ...
... if it isn't why not simply fix the dynamic sql to look like (after creating the CustomerMaster table) ....
IF Exists(SELECT Customer...
December 8, 2008 at 10:15 pm
Bah! PASS is not a "Professional" association - its simply a personal networking and vendor spruiking opportunity!
Where's the expression on required standards of members behaviour and ethics, sanctions for malpractice,...
August 21, 2006 at 7:07 am
Viewing 13 posts - 1 through 13 (of 13 total)