Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Oct 18, 1999

Precise Division

Question:
I have var1 and var2 both ints in a DB (only ints will be entered into var1, var2). But I want the result to show answer with decimal places:
 
SELECT var1/var2 as Result
Right now it says 10/3 = 3.

Can I specify the datatype of "Result"?

Answer:
Nope. That's all you're going to get, because ints are ints. You need to start with a datatype that shows precision and scale to get them in a result.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date