|
Posted by Plamen Ratchev on 04/10/07 21:46
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns990F2D6DACA2Yazorman@127.0.0.1...
>
> you don't say whether you tried this, but I can see that it will fail
> with integer overflow. Howeever this should work:
>
> SELECT SUM(cast(datalength(document) as bigint)) FROM plan_report
>
Good catch Erland! I didn't see the big number and the overflow...
Plamen Ratchev
http://www.SQLStudio.com
Navigation:
[Reply to this message]
|