| Author |
 Topic  |
|
|
muzishun
Senior Member
United States
1079 Posts |
 Posted - 16 December 2004 : 11:45:43
|
| I'm currently trying to learn how to use SQL Queries to connect to databases. I've found one site in particular, http://sqlcourse.com/, that I'm using almost exclusively. It's the most comprehensive and thorough tutorial I've found so far. The only problem is when they mention the 'CREATE TABLE' command, they only mention the most common data types. I know there's more out there, but I can't seem to find a list. Does anyone know where I can find a comprehensive list of the possible data types used with the 'CREATE' command? Thanks in advance. |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 16 December 2004 : 12:17:37
|
| It really all depends on the database type. What database are you using that you're having difficultly with the data types? |
 |
 |
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 16 December 2004 : 14:50:09
|
| Well, I'm starting to work on a Bios page for members of my site. This won't interact with the forum at all. It is an Access Database. I've got everything working so far (with the exception of the bug I posted in another thread). However, I know that one of the data types Snitz uses is an AutoNum. I haven't found anything detailing this one, so I'm assuming that the lists I've found are incomplete (they also usually state that there are more.. just no links to where they are). |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 16 December 2004 : 15:00:51
|
Access - Autonumber
SQL Server - int identity (autoidentifyer)
Both of these serve as an auto-incrementing number for uniquely identifying records |
-Stim |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 16 December 2004 : 16:53:47
|
Open help in Access, go to the Jet SQL Reference chapter, and in the Overview section look at the datatypes available for Access.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 16 December 2004 : 18:36:26
|
| Thanks for the help! |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
|
|
| |
Topic |
|
Topic Locked
