Viewing 9 posts - 1 through 9 (of 9 total)
yes I tried that, no difference
March 7, 2015 at 4:41 am
GilaMonster (12/30/2014)
SELECT * FROM TableName WHERE DateTimeColumn = '2014-12-28 08:52:02.920'
Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted in...
December 30, 2014 at 11:01 am
Recovery model says: SIMPLE 🙂
The backup command is
/SQL "Maintenance Plans\(databasename) Integrity und Backup" /SERVER (servername) /CHECKPOINTING OFF /SET "\Package\Subplan_1.Disable";false /REPORTING E
done once daily.
-mpe
January 14, 2013 at 3:34 am
interesting indeed! thanks for the little piece of code!
SELECT T1 FROM #T returns "1E-06" and "1E-05" for the first two lines (called from the SSMS)
-Michael
December 18, 2012 at 8:59 am
> sometimes float values are returned as "0E-7" instead of "0.0000000" or "4E-7" instead of "0.0000004"
what is the rule then ... when are numbers displayed like that and when not?
-m
December 18, 2012 at 1:46 am
thanks for the quick reply ... can I simply change the data types in the table design view? will the data that are already in there stay unharmed by this...
December 17, 2012 at 11:20 am
Viewing 9 posts - 1 through 9 (of 9 total)