Web Wiz
Home
Home
Hosting Services
Hosting Services
Knowledgebase
Knowledgebase
Community and Support Forums
Support Forums
Customer Login
Customer Login

  New Posts New Posts RSS Feed - My SQL vs MS SQL PROBLEM,HELPP !!!
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Windows Web Hosting 30 Day Free Trial

Windows Web Hosting 30 Day Free Trial

Windows Hosting 30 Day Free Trial, with no obligation, on all our Windows Web and Reseller Hosting Packages.

For moreĀ informationĀ see our Windows Hosting 30 Day Free Trial page.

My SQL vs MS SQL PROBLEM,HELPP !!!

 Post Reply Post Reply
Author
sexy_july View Drop Down
Newbie
Newbie
Avatar

Joined: 05 October 2009
Location: Philippines
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote sexy_july Quote  Post ReplyReply Direct Link To This Post Topic: My SQL vs MS SQL PROBLEM,HELPP !!!
    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
Nune View Drop Down
Newbie
Newbie
Avatar

Joined: 28 July 2009
Location: Yerevan
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote Nune Quote  Post ReplyReply Direct Link To This Post 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
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



Become a Fan on Facebook Follow us on Twitter Find us on Google+ Community Forums Web Wiz Blogs Web Wiz News
Company Information | Contact Web Wiz | Terms & Conditions | Privacy Policy

Prices exclude VAT unless otherwise stated - $, € prices shown as a guideline only
Web Wiz Ltd, Unit 10E Dawkins Road Ind. Est, Poole, Dorset, UK, BH15 4JD
Copyright ©2001-2012 Web Wiz - All rights reserved