SQL Int to Decimal Data Type - Alter Table
I had a problem recently when some automatic updates were not processing due to the data needing more decimal places.
I found a solution to change a field data type from Int to Decimal you can try this:
Alter table yourtable_
Alter Column yourtable_number Decimal(10,2)
The 2 numbers inside the brackets represent total 10 digits and in which 2 are after the decimal.
Eg yourtable_number data 3412 becomes 3412.00
Topics: SQL | 1 Comment »
iPhone Web Applications or iPhone Websites
After waiting what seemed an eternity, the iPhone 3G has finally arrived.
There are big benefits to companies and organizations who develop applications or marketing campaigns on mobile devices.
Users on mobile devices usually only have a short period of time to browse and view information, or are searching for information fast.
iPhone Web Applications or iPhone Websites provide direct access to information within a single link.
Web applications can be deployed quickly at low cost making them a great opportunity for your company to communicate with users.
If your company wants more exposure at the fingertips of innovators (users who pickup technology quickly), then you need a mobile solution so your clients can access what they want quickly with just a few touches.
Measurable results? You bet. Just another benefit of a web application that integrates into your marketing strategy.
For more information on iPhone Web Applications, contact Feris Internet Marketing.
Topics: iPhone Web Applications | No Comments »
Next Entries »