Ycsoftware.net
Menu
  • Databases
    • MySQL
    • MS SQL Server
    • Foxpro
  • Programming
    • .NET
    • C#
    • Drupal
    • Java
    • PHP
    • Javascript
  • System Administration
    • Hardware
    • Linux
    • MAC
    • Virtual Servers
    • VMWARE
    • Servers
    • VirtualBox
  • Web Design
    • CSS
    • Flash
    • HTML
    • SEO
  • Other
  • Contact Us
    • About Us

Category : Databases

Mysl, MSSQL, Oracle, SQLITE, POSTGRES

MySQL and MSSQL Maximum Integer (Numeric) Values

  • March 30, 2011

MySQL TINYINT   127 SMALLINT   32767 MEDIUMINT   8388607 INT 2147483647 BIGINT   9,223,372,036,854,775,807 MSSQL TINYINT 255 SMALLINT 32767 INT 2147483647 BIGINT 9,223,372,036,854,775,807 Reference MSSQL http://msdn.microsoft.com/en-us/library/aa258271(v=sql.80).aspx MySQL http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

    • Databases
    • MS SQL Server
    • MySQL
    • Programming

Cannot Update Cursor Visual Foxpro

  • January 26, 2011

If some of your users get this error while others do not get this error message, you might need to : Check the ntfs permissions on the files.

    • Databases
    • Foxpro
    • Programming

Update Fields (Memo) Between two Foxpro Database Tables

  • January 21, 2011

Dealing with Memo Fields in FoxPro in not always straightforward especially if you work on an older version of that software (version 6 and version 7) and also if you spent a couple years away … Read more

    • Databases
    • Foxpro

Add and Subtract Hours to T-SQL Datetime

  • December 10, 2010

Add to 1 hour to the Current Date DATEADD(hh,1,getdate()) Subtract 1 hour to the Current Date DATEADD(hh,-1,getdate()) Add 1 hour to the Current Time and returns just the time part select Convert(varchar,( DATEADD(hh,-1,getdate())),8) Reference http://msdn.microsoft.com/en-us/library/ms186819.aspx

    • MS SQL Server
    • Programming

Saving Changes is not Permitted

  • December 9, 2010

Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the … Read more

    • Databases
    • MS SQL Server
    • Programming
« Older Posts
Newer Posts »

Search

Search

YCSoftware Recent Comments

Thanks very much !!!...
Just testing...
Awesome, problem solved. Thanks man....
REboot the MAC and Try to redownload the JDK. It might be that the JDK...
When I download the new JDK for Mac it says the disk image is not reco...
You are my hero for posting this....
Greetings! Very useful advice in this particular article! It's the ...
I love what you guys are up too. This type of clever work and reportin...
relates to. To fix that you can either include the path to mysqldump e...
By implementing all these third-party tacked on start menus, all we’...

Tags

.net C# Centos 5 interest internet Microsoft Access Microsoft Office Programming technology thinker vmware vmware tools

Sponsors

YCSoftware
  • © 2025 Ycsoftware.net
Top