Print Page | Close Window

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 Confused ,

 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 Confused ),

but in My SQL 5 is 2147484289 (positive number Confused ), 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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net