1 / 17

Basis Data Terapan

Basis Data Terapan. Yoannita. SQL Server Data Types. Character strings:. SQL Server Data Types. Unicode strings:. SQL Server Data Types. Binary types:. SQL Server Data Types. Number types:. SQL Server Data Types. Number types:. SQL Server Data Types. Date types:.

haven
Download Presentation

Basis Data Terapan

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Basis Data Terapan Yoannita

  2. SQL Server Data Types • Character strings:

  3. SQL Server Data Types • Unicode strings:

  4. SQL Server Data Types • Binary types:

  5. SQL Server Data Types • Number types:

  6. SQL Server Data Types • Number types:

  7. SQL Server Data Types • Date types:

  8. SQL Server Data Types • Other data types:

  9. MySQL Data Types • Text types(i):

  10. MySQL Data Types • Text types (ii):

  11. MySQL Data Types • Number types (i):

  12. MySQL Data Types • Number types(ii) :

  13. MySQL Data Types • Number types(iii) : • *The integer types have an extra option called UNSIGNED. Normally, the integer goes from an negative to positive value. Adding the UNSIGNED attribute will move that range up so it starts at zero instead of a negative number.

  14. MySQL Data Types • Date types:

  15. MySQL Data Types • Date types: • *Even if DATETIME and TIMESTAMP return the same format, they work very differently. In an INSERT or UPDATE query, the TIMESTAMP automatically set itself to the current date and time. TIMESTAMP also accepts various formats, like YYYYMMDDHHMMSS, YYMMDDHHMMSS, YYYYMMDD, or YYMMDD.

  16. Microsoft Access Data Types(i) http://www.w3schools.com/sql/sql_datatypes.asp

  17. Microsoft Access Data Types(ii) http://www.w3schools.com/sql/sql_datatypes.asp

More Related