Viewing 15 posts - 53,791 through 53,805 (of 59,068 total)
And (missed it), Antares has even better reasons...
November 30, 2007 at 1:21 pm
Heh... there's just a pot-wad of undocumented features and sprocs in SQL Server... most would warn against using them because if they're undocumented, they could disappear on the next service...
November 30, 2007 at 1:18 pm
For me, it's because most things that you query are tables... for a view or a function, you might want to use the Hungarian notation to make it obvious that...
November 30, 2007 at 1:06 pm
Not odd behaviour... same as what happens with most numeric datatypes...
DECLARE @Datum2 INT
SET @Datum2 = ''
SELECT @Datum2
November 30, 2007 at 11:59 am
IF OBJECT_ID('TempDB..##my_temp_table','U') IS NOT NULL
PRINT 'Table Exists'
ELSE
...
November 30, 2007 at 11:55 am
Use WITH ROLLUP... search for the correct "NULLS"...
November 30, 2007 at 11:47 am
CREATE TABLE #DirInfo
(
SubDirectory SYSNAME,
Depth...
November 30, 2007 at 11:45 am
you need to first EXPAND the precision BEFORE the operation, and then DECREASE the PRECISION when you're done....
Heh... and what better way to do that than to use FLOAT...
November 30, 2007 at 11:21 am
b_boy (11/29/2007)
November 30, 2007 at 11:08 am
"That's the way we do it here".
Heh... that reminds me of a saying...
"Even if the majority agrees on an idiotic idea... it's still an idiotic idea." 😛
November 30, 2007 at 10:52 am
Heh... thanks for that, Jason. Hope a couple of other folks take heed of that little lesson...
In the meantime, what's the best way for me to get this dried...
November 30, 2007 at 10:48 am
Heh... oh yeah... almost forgot...
"NO... I am NOT smarter than a 5th grader!" 😛
November 30, 2007 at 10:41 am
Another surprising for someone result comes from simple primary school exercise.
X / N * M = X * M / N
Is it true?
( :blush: Wait a minute...
November 30, 2007 at 10:34 am
Viewing 15 posts - 53,791 through 53,805 (of 59,068 total)