Web Wiz Forums Homepage
Forum Home Forum Home - General Discussion - Database Discussion
  New Posts New Posts RSS Feed - My SQL vs MS SQL PROBLEM,HELPP !!!
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

My SQL vs MS SQL PROBLEM,HELPP !!!

 Post Reply Post Reply
Author
Message
Nune View Drop Down
Newbie
Newbie
Avatar

Joined: 28 July 2009
Location: Yerevan
Status: Offline
Posts: 1
Points: 2
Post Options Post Options   Quote Nune Quote  Post ReplyReply Direct Link To This Post Topic: My SQL vs MS SQL PROBLEM,HELPP !!!
    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" ="">
Back to Top
sexy_july View Drop Down
Newbie
Newbie
Avatar

Joined: 05 October 2009
Location: Philippines
Status: Offline
Posts: 2
Points: 2
Post Options Post Options   Quote sexy_july Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Bulletin Board Software by Web Wiz Forums® version 10 alpha build 20092001
Copyright ©2001-2009 Web Wiz

This page was generated in 0.068 seconds.