My SQL vs MS SQL PROBLEM,HELPP !!!
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=27639
Printed Date: 28 March 2026 at 7:16am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: My SQL vs MS SQL PROBLEM,HELPP !!!
Posted By: Nune
Subject: My SQL vs MS SQL PROBLEM,HELPP !!!
Date Posted: 29 July 2009 at 8:39am
Hello I need help  ,I have this formula select ((m * power(2,7) + n) | 0x80000000) , where n,m are positive numbers, in any case the result is different in both servers :eek:, for example if n=5,m=1 the result in MS SQL 2000 is -2147483007 (negative number ), but in My SQL 5 is 2147484289 (positive number ), but in my application I need negative number in result. How can I adjust this formula in order to get the same result like in SQL Server ? Can anyone help me to solve this issue ? Please help to solve this. Any help is appreciated. Thanks in advance. < id="gwProxy" ="">< ="jsCall;" id="jsProxy" =""> |
Replies:
Posted By: sexy_july
Date Posted: 05 October 2009 at 2:05pm
|
you must able to search on the internet the correct formula i will ask my friend about your problem maybe he can help you ------------- http://www.google.com" rel="nofollow - google |