By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,472 Members | 1,199 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,472 IT Pros & Developers. It's quick & easy.

working with large numbers

P: n/a
I need to compute factorials, but I hit a limit around 170!. Is there
anyway to handle numbers larger than the float data type can handle?
Thanks.

Nov 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
You can try DECIMAL(n), but this is not what SQL ws meant to do. Can
you get Mathematica or Maple or MathLab instead?

Nov 23 '05 #2

P: n/a
--CELKO-- (jc*******@earthlink.net) writes:
You can try DECIMAL(n), but this is not what SQL ws meant to do. Can
you get Mathematica or Maple or MathLab instead?


decimal is not going to help here. I ran 170! on my pocketcalculator, and it
said something about E306.

But I agree that SQL Server is not really the best place for this
exercise.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Nov 23 '05 #3

P: n/a
With SQL 2005 you can define true new types using .NET. This is a
sample of a good use of the CLR inside SQL Server.

Nov 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.