 |
|
 |
My SQL vs MS SQL PROBLEM,HELPP !!! |
Post Reply 
|
| Author |
 Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search  Topic Options
|
Nune 
Newbie 
Joined: 28 July 2009 Location: Yerevan Status: Offline Posts: 1 Points: 2 |
 Post Options
 Quote Reply
 Topic: My SQL vs MS SQL PROBLEM,HELPP !!!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" =""> |
|
 |
|
|
sexy_july
Newbie
Joined: 05 October 2009 Location: Philippines Status: Offline Posts: 2 Points: 2 |
Post Options
Quote Reply
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 |
|
|
|
|
Post Reply
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
All prices are shown excluding VAT, which is charged where applicable. $, € prices shown as a guideline only.